how to change the axis x for 2 series start 0 at the middle....
Ex: 70-----35----0-----35----70
______ __________
__ _______

Is it a horizontal bar chart? Then the horizontal axis is actually the Y
axis (dependent variable)

Double click on the axis, click on the Scale tab, and change the min, max,
and major unit as needed. If you want the bars to go left and right from the
Y=0 vertical line, make sure the X axis crosses the Y axis at zero (this is
in the same dialog as setting the axis scale). Then double click the X axis,
and on the Patterns tab for Tick Labels, choose Low to move the labels to
the left of the chart.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Tin MIn MIn" <Tin MIn MIn @discussions.microsoft.com wrote in message
...
how to change the axis x for 2 series start 0 at the middle....
Ex: 70-----35----0-----35----70
______ __________
__ _______