Creating a bar chart with secondary axis for line chart

[manish agarwal]

Hi,

I am wondering how to create a bar chart in the primary axis which can show the different profit figures like gross profit, net profit, etc over a period of time with line chart on secondary axis for percentage values of their growth in the same period of time. I've attached a sample file. I am using excel mac 2011. I am able to achieve this with only one profit figure and one percentage data series, but unable to do with more than one.

Thanks in advance,
Manish

 

[p45cal]

Attached done in Excel 2003.

 

[manish agarwal]

Hi, Many Thanks, after seeing your file, I re-tried on mac excel 2011 and what i did was to switch rows and columns and then individually select the series from the chart and place them on the secondary axis. How did you do?

 

[bobhc]

A very often asked question with many reply's, the search box does work its not just there to look pretty.

 

[manish agarwal]

I really searched in the search box but did not get what i was looking for. I am sorry, but could you show me if the question i asked is already there? I;ll be greatful