Different X-axis labels for different Series in same chart

[Guest]

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

 

[David Biddulph]

If you have an XY (scatter) chart, you can add a secondary X axis.

 

[Jon Peltier]

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