is it possible to have a secondary axis on a line chart?

[#1]

for instance right now I have one line graph showing the average response time by region and another showing how many orders each region has.  I want to be able to show the response time by region and also the number of orders each region has.  Any suggestions?

Thanks in advance!

[reddy-s · Accepted solution]

Hi Sam,

Its not possible to have a secondary axis on a line chart. Instead make use of a combo chart to achieve the same.

You will be able to plot two lines with independent axis.

[#3]

Hi Sangram,

Could you please explain a bit more on this. since I am having two bars with values in Millions and a line showing the division of both i.e. value of line varies from -1 to 1.