If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
data to chart on primary axis
I have a series that I chart as a column, "Precipitation"
and three series that I chart as XY Scatter, "Plant Cover 1"... I created the chart as a column chart and when I change each of the "Plant Cover" series to an XY Scatter, Excel chooses the "Precipitation" column to plot on the primary axis. I would like "Precipitation" on the secondary axis so the chart matches the format of my other charts. I have tried to select the XY Scatter series and put them on the primary axis, but the column just disappears. I have tried starting with an XY Scatter chart first also, and then changing the "Precipitation" Sometimes I am able to get the graph I am looking for with experimentation. But I never find a method I can write down and use the next time. For example, when I try to put "Precipitation" on the second axis and select Secondary Y and Secondary x axes, sometimes the column charts from the top of the chart down. How can I find a consistent method? Thank you in advance for any suggestions! |
Thread Tools | |
Display Modes | |
|
|