Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How to Chart XXY axis with different X axises
Hello all,
I have been searching around the forum to see if I can find an answer to create a XXY chart. I found one answer but it was not working for my case. Please help. X(1) will be in top, X(2) bottom. Plot Y1 and Y2. Thanks much! X axis(1) X axis(2) Y(1) Y(2) Jan-06 1/1/06 3 0 Feb-06 1/1/06 5 0 Mar-06 3/5/06 0 0 Apr-06 3/6/06 1 0 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
How to Chart XXY axis with different X axises
Every series needs X values and Y values. Select the X and Y data for one
series and make your chart. Copy the X and Y data, select the chart, use Paste Special from the Edit menu to add the data as a new series, with category (X) values in the first column. Double click one series, and on the Axis tab, select Secondary. Go to Chart Options on the Chart menu, and on the Axes tab, check and uncheck boxes until the combination of axes you need is checked. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "luvgreen" wrote in message ... Hello all, I have been searching around the forum to see if I can find an answer to create a XXY chart. I found one answer but it was not working for my case. Please help. X(1) will be in top, X(2) bottom. Plot Y1 and Y2. Thanks much! X axis(1) X axis(2) Y(1) Y(2) Jan-06 1/1/06 3 0 Feb-06 1/1/06 5 0 Mar-06 3/5/06 0 0 Apr-06 3/6/06 1 0 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
How to Chart XXY axis with different X axises
Jon, this is very helpful. You are the master of excel chart. Thank you for
your help. luvgreen "Jon Peltier" wrote: Every series needs X values and Y values. Select the X and Y data for one series and make your chart. Copy the X and Y data, select the chart, use Paste Special from the Edit menu to add the data as a new series, with category (X) values in the first column. Double click one series, and on the Axis tab, select Secondary. Go to Chart Options on the Chart menu, and on the Axes tab, check and uncheck boxes until the combination of axes you need is checked. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "luvgreen" wrote in message ... Hello all, I have been searching around the forum to see if I can find an answer to create a XXY chart. I found one answer but it was not working for my case. Please help. X(1) will be in top, X(2) bottom. Plot Y1 and Y2. Thanks much! X axis(1) X axis(2) Y(1) Y(2) Jan-06 1/1/06 3 0 Feb-06 1/1/06 5 0 Mar-06 3/5/06 0 0 Apr-06 3/6/06 1 0 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Chart Axis naming question | Charts and Charting in Excel | |||
Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis | Charts and Charting in Excel | |||
Stacked Bar Chart with Secondary Axis | 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 |