Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Different X-axis labels for different Series in same chart
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Different X-axis labels for different Series in same chart
If you have an XY (scatter) chart, you can add a secondary X axis.
-- David Biddulph "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 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Chart series | Charts and Charting in Excel | |||
Scatter chart with text labels as Y axis? | Charts and Charting in Excel | |||
Missing x-axis labels on chart in XL97 | Charts and Charting in Excel | |||
Fan charts | Charts and Charting in Excel | |||
Bar chart & Category (x) axis labels | Charts and Charting in Excel |