Dual axis with Bar chart + two series : is it possible ??

[lOURY]

Hi,

I'm looking for info on personnalized charts. I know that in the
personnalized type graphs Excel has a "Bar Chart + Plotted serie" with two y
axis'.

I would like to have a bar chart + two plotted series so the chart would be
:

x axis : data ( month, location...)
y axis n°1 ( left side) = bar chart scaling 0 to 400
y axis n°2 (right side) = TWO series scaling 10 to 50


Any help ?

 

[Tushar Mehta]

Create a chart with all three series. Then, double-click one of the
series you want on the secondary y-axis and in the resulting dialog
box, from the Axis tab select Secondary. Repeat for the 2nd series you
want on the secondary axis.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[lOURY]

Thank you !
"Tushar Mehta" <[email protected]> a écrit dans le
message de Create a chart with all three series. Then, double-click one of the
series you want on the secondary y-axis and in the resulting dialog
box, from the Axis tab select Secondary. Repeat for the 2nd series you
want on the secondary axis.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[Tushar Mehta]

You are welcome. Glad to be of help.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions