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

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 ?

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

--=20
Regards,

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

In article , =20
says...
Hi,
=20
I'm looking for info on personnalized charts. I know that in the
personnalized type graphs Excel has a "Bar Chart + Plotted serie" with tw=
o y
axis'.
=20
I would like to have a bar chart + two plotted series so the chart would =
be
:
=20
x axis : data ( month, location...)
y axis n=B01 ( left side) =3D bar chart scaling 0 to 400
y axis n=B02 (right side) =3D TWO series scaling 10 to 50
=20
=20
Any help ?
=20
=20
=20

Thank you !
"Tushar Mehta" a écrit dans le
message de news:MPG.1a9bf7d94c74bdc09896f4@news-server...
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

In article ,
says...
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 ?

You are welcome. Glad to be of help.

--=20
Regards,

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

In article , =20
says...
Thank you !
"Tushar Mehta" a =E9crit dans l=
e
message de news:MPG.1a9bf7d94c74bdc09896f4@news-server...
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.
=20
=20