Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Updating a graph with 2 y axis
Hi, I have a Graph which on 1 axis which has 2 datalines shown as a line.
and a 2nd axis which is a combined block. I am trying to add a 3rd item to the 1st axis but cannot get it to show as a line or on the same axis? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Updating a graph with 2 y axis
Garfiled wrote:
Hi, I have a Graph which on 1 axis which has 2 datalines shown as a line. and a 2nd axis which is a combined block. I am trying to add a 3rd item to the 1st axis but cannot get it to show as a line or on the same axis? Right click on the graph line you want to change. and select "FormatDataSeries", then on the "Axis" tab you can select to "PlotSeriesOn" which ever axis you want. Bill |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Updating a graph with 2 y axis
Hi Bill.
When I add a new series and then "plot series on" It gives me NEW COLOUM? Regards "Bill Martin" wrote: Garfiled wrote: Hi, I have a Graph which on 1 axis which has 2 datalines shown as a line. and a 2nd axis which is a combined block. I am trying to add a 3rd item to the 1st axis but cannot get it to show as a line or on the same axis? Right click on the graph line you want to change. and select "FormatDataSeries", then on the "Axis" tab you can select to "PlotSeriesOn" which ever axis you want. Bill |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Updating a graph with 2 y axis
And if you right click on it, what do you see?
Bill ------------------------------ "Garfiled" wrote in message ... Hi Bill. When I add a new series and then "plot series on" It gives me NEW COLOUM? Regards "Bill Martin" wrote: Garfiled wrote: Hi, I have a Graph which on 1 axis which has 2 datalines shown as a line. and a 2nd axis which is a combined block. I am trying to add a 3rd item to the 1st axis but cannot get it to show as a line or on the same axis? Right click on the graph line you want to change. and select "FormatDataSeries", then on the "Axis" tab you can select to "PlotSeriesOn" which ever axis you want. Bill |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Want graph with 2 axis, but bars overlap when second axis added | Charts and Charting in Excel | |||
How to specify values for X axis in a Graph | Charts and Charting in Excel | |||
2 axis bar graph | Excel Discussion (Misc queries) | |||
How do you do a graph with a second Y axis? | Excel Discussion (Misc queries) | |||
Y Axis - Horizontal Bar Graph | Charts and Charting in Excel |