gerrite.blogg.se - How to plot a graph in excel with two y axis

Take your finger off CTRL between selecting each column. In this case the impressions and Revenue columns.

Click in the Chart Data Range and whilst holding CTRL highlight the data that you want to include in the chart.

Right click on the box that comes up and click on Select Data.

At the top of you toolbar select Insert, Line and click on the first line graph.

So now we will show you how to create a graph that looks like this…Īs can clearly be seen, there is quite a strong correlation between the amount of impressions and the revenue, with revenue being generated slightly after the initial impressions. As you can see the amount of impressions is unidentifiable as the numbers are so low compared with the revenue. If we were to create a normal singular line graph for the impressions vs revenue the graph would look like the below.

You may need this secondary axis graph for a number of reasons however using the sample data below we are going to create a graph to show the quantity of impressions to a website over time, compared with the revenue over that same period of time. These graphs are called double axis or secondary axis graphs. Sometimes however, there is need to create one single chart for two different, yet related, pieces of data. Normally a line or bar chart is sufficient enough to show off the data being analysed, helping to show trends, year on year differences, spikes and depressions. They can include bar charts, line and scatter graphs and many more. You may find it useful to use the "more options" option from the image above on the secondary y-axis to ensure it matches your requirements, you can also hide the secondary y-axis, if needed, from the same place.Microsoft Excel’s chart functions help readers quickly visualise information and see insights buried within sheets of endless data. Right-click the chart itself and click Select Data., select on of the series to use the secondary axis and define the Horizontal (Category) Labels.įrom the ribbon make the Secondary Axis visible, like so:

And inside the Series Options tab choose Secondary Axis. Right-click the series line for each series that should use the secondary pair of axis, select Format Data Series. Instructions:Ĭreate your basic chart with the required series. You can have a "primary" and "secondary" axis in some chart types (line, column and bar at least maybe others) - they are in pairs so you can't have a secondary x-axis without a secondary y-axis, but you can make the secondary y-axis identical to the primary version, and then hide it, so it has no effect on the graph.