View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Different X-axis labels for different Series in same chart

Do you mean X-axis labels? Then you can add a secondary X axis. First,
double click one series, and on the Axis tab, select Secondary. Then if you
don't get a secondary X axis (usually across the top of the chart), go to
Chart menu Chart Options Axes tab, and check the Secondary Category (X)
Axis box.

Do you mean X values (numerical)? Then don't make a line chart, make an XY
chart. In a line chart, all series must use the same categories, which are
treated as non-numerical text labels. In an XY chart, the X axis is a
continuous numerical scale, and the series use independent sets of X values.

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


"gmontgomery" wrote in message
...
Is there a way for me to make the X-axis reflect different labels for a
2nd
and 3rd series in the same chart. In the 1st series when I put in the
value
for the X axis, I have it show this value in the data label and not along
the
bottom of the chart. I want to do the same thing for the additional
series
but when I go to change the X axis in the 2nd series, it changes it for
the
1st series as well and since the information is different it doesn't do
what
I need it to. Please help. Thanks, Gabrielle