Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I add a second y-axis?
I am creating a graph in Excel 2002. I have 2 data series and I need 2 y-axis
due to different concentrations between the 2 data series. Everytime I try to add the 2nd axis, I can only view one of the data series. |
#2
|
|||
|
|||
If you are using a secondary axis, check the scaling on both axes. You may
have it set so that you can't see one of the series. "Laura" wrote in message ... I am creating a graph in Excel 2002. I have 2 data series and I need 2 y-axis due to different concentrations between the 2 data series. Everytime I try to add the 2nd axis, I can only view one of the data series. |
#3
|
|||
|
|||
Barb,
It seems that when I envoke the 2nd axis, it superimposes the one data series on top of the other. Ideally, I would like the scales to be the same on both axis, I just need to show that the units of measurment for the 2 data series were different. I suggested to our client to just add a footnote, but they definitely want 2 axis. Any thought? "Barb Reinhardt" wrote: If you are using a secondary axis, check the scaling on both axes. You may have it set so that you can't see one of the series. "Laura" wrote in message ... I am creating a graph in Excel 2002. I have 2 data series and I need 2 y-axis due to different concentrations between the 2 data series. Everytime I try to add the 2nd axis, I can only view one of the data series. |
#4
|
|||
|
|||
Can you give an example of your data sets and the Primary and Secondary Y
axis ranges? Alternatively, something like this might work for you: http://peltiertech.com/Excel/Charts/axes.html#StakCht but I'd work on the secondary axis first before embarking on Stacked charts. "Laura" wrote in message ... Barb, It seems that when I envoke the 2nd axis, it superimposes the one data series on top of the other. Ideally, I would like the scales to be the same on both axis, I just need to show that the units of measurment for the 2 data series were different. I suggested to our client to just add a footnote, but they definitely want 2 axis. Any thought? "Barb Reinhardt" wrote: If you are using a secondary axis, check the scaling on both axes. You may have it set so that you can't see one of the series. "Laura" wrote in message ... I am creating a graph in Excel 2002. I have 2 data series and I need 2 y-axis due to different concentrations between the 2 data series. Everytime I try to add the 2nd axis, I can only view one of the data series. |
#5
|
|||
|
|||
Laura -
If the scales are the same on both axes, isn't the second axis redundant? You can reflect different units in the axis title: "Weight (lb) or Distance (miles)". - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Laura wrote: Barb, It seems that when I envoke the 2nd axis, it superimposes the one data series on top of the other. Ideally, I would like the scales to be the same on both axis, I just need to show that the units of measurment for the 2 data series were different. I suggested to our client to just add a footnote, but they definitely want 2 axis. Any thought? "Barb Reinhardt" wrote: If you are using a secondary axis, check the scaling on both axes. You may have it set so that you can't see one of the series. "Laura" wrote in message ... I am creating a graph in Excel 2002. I have 2 data series and I need 2 y-axis due to different concentrations between the 2 data series. Everytime I try to add the 2nd axis, I can only view one of the data series. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change axis info on radar charts | Charts and Charting in Excel | |||
space between y axis and data points.. | Charts and Charting in Excel | |||
How do I set permanent secondary axis in PivotTable chart? | Charts and Charting in Excel | |||
Second X axis at top of chart? | Charts and Charting in Excel | |||
Labels on Chart with Negative Value Axis | Charts and Charting in Excel |