View original (French)

3-Axis Y Chart Excel

Solved
logan989 Posted messages 39 Status Membre -  
logan989 Posted messages 39 Status Membre -
Hello,

I am currently looking for a way to create a chart with 3 Y axes in Excel 2003. I want to show 2 curves (Revenue and Profit) and a histogram (Headcount), all for the same period.
The X axis is fine, but so far I can only overlay my 2 curves using the "2-axis charts" tool in custom types. I am therefore missing the histogram that I want to add to the same chart.

Thank you for your help.

Configuration: Windows XP / Internet Explorer 7.0

2 réponses

Réponse 1 / 2
Pascal
 
Build the chart with the 3 data series, type curves
Select the series to modify by double-clicking
In the axis selection tab, check Secondary Axis, then OK
In the chart menu, select chart type, histogram. It will only apply to the selected series.
11
logan989 Posted messages 39 Status Membre
 
Thank you,
Okay for the histogram type.
But I don't have the 3 desired Y axes. I have one for the histogram and one for the two other curves, whereas I want a separate axis for each curve.
0