three data series in excel with dual axes

[mmr3b9]

Hi,

Can anyone tell me if it is possible to create three data series in with dual axes in one chart using excel. I have done it with two data series but i dont know if you can do it with three. I am using office 2000.

If someone can help me out I would appreciate it.

Thanks,
Mike

 

[SkipVought]

Hi,

So 2 series use one y axis and the 3rd uses the secondary y axis?

Line, scatter, bar?????

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[SkipVought]

Select the x-axis data and the series for the primary axis -- activate the chart wizard and complete.

Select the series data for the secondary axis and copy.

Activate the chart and Edit/Paste Special

select the new series and format - axis secondary axis



Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com