No, first we will draw a line chart.
For overnight profit data.
So this is the line that we want from this data.
So to draw a line chart.
Go to insert.
Click on this insert line and reach out and select.
This line with Marguerita.
Here, the first step is to select data, so go to design tab and click on select data.
Here on the legend entry, authorities say we have to select the data that we want on the Y-axis and
on the horizontal axis.
We have to give this year's column.
So click on that.
The city's name is this nonprofit, and the city's value is.
This.
So this is our first cities that is net profit now, the second cities we want is net profit margin.
So again, click on ADD.
The city's name is net profit margin and.
The city's values are located or here.
So click on the.
Now for horizontal axis, currently we are getting one, two, three, four, five and six, but we
don't want this value.
We want the air values to click on edit and select the range.
So now our chart is looking good.
Means we have.
I did all the data horizontal axis is looking good on the vertical axis, we have to see this net profit
margin and net profit.
So click on OK, now you can see that the net profit values are in hundreds of thousand, whereas the
net profit values are in decimal point zero point zero eight or zero point zero nine.
So that's way for this net profit margin.
All our values are lying near to zero.
We cannot analyze these values by looking at the graph.
For such cases, when there is a huge difference between both of the cities numbers, we can use secondary
access.
So click on your cities.
So, for example, this is our cities.
Try to click on this now, our second series of selected.
Now, go to this option, third option and click on secondary access.
Now, just after plugging the secondary axis, you will find that.
Secondary axis appears on the right hand side of your chart, and here you can see that the values are
from zero to 14 percent.
So that's so we add secondary access.
Now, these two lines are coinciding and it may be confusing for other users to analyze this.
So we will shift this axis a little bit down so that these two lanes are separated now.
To do that, we can tweak the upper limit and lower limit of the secondary axis.
So click on your secondary axis.
Selected and go to this exercise option and in this exercise options.
You can set bond for your secondary or primary access.
So right now, the lowest or minimum bond is zero.
That's why the axis is starting from zero and the maximum bond is one one four or 14 percent.
That's where the X's values are going for 10 percent.
Now we can change this minimum one two point zero five or five percent.
And we can tweak this upper bound to guarantee.
20 percent or 2.0.
So you can see that now both of these two lines are separated and we can clearly identify the pattern
for this orange lane, we can use the secondary access.
And for this blue line, which is a nonprofit, we can use the primary access.
Now, the job titles are missing and the agents are also missing, so to add to our title and digital
agents, we can click on this plus icon, go to this legend.
And using this drilldown menu, we can also select the location for legends.
I want legends to be at the bottom of my chart.
Now you can see that we have a and non profit and that profit margin to return.
On their third title, Esben.
So click on title.
And the title is Profit and Profit Margin.
Just copy and paste it in your chart data.
And he says, now you can see that our chart is ready, we are able to identify patterns in our data.
We have the title, we have our agents and we are ready to line cities in our line to.