Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I add a second y-axis in an xy(Scatter) chart?
I would like to create a xy-scatter chart for a dataset with two different
x-axis. I have one set of data, but I need to plot it against two axis, "concentration" and "dilution factor". The dilution (and therefore the concentration) is not linear, so a line chart will display the data "distorted" or "skewed". I tried the tip from bj (9/9/2005 4:44 AM PST, to the question "Line chart or scatter chart??") there can be two x axis in a scatter chart. first select one of the data series and <axis select secondary next in <chart<chart options<axis select secondary x axis. by duplicating the data. But I could not find any possibility to enable the "second category (x) axis", it stays disabeld even with two data series. (I'm using Excel 2003.) |
#2
|
|||
|
|||
How do I add a second y-axis in an xy(Scatter) chart?
Hi,
Here is an explanation of how to use the secondary axes. http://www.andypope.info/tips/tip008.htm Cheers Andy Kinno Katana wrote: I would like to create a xy-scatter chart for a dataset with two different x-axis. I have one set of data, but I need to plot it against two axis, "concentration" and "dilution factor". The dilution (and therefore the concentration) is not linear, so a line chart will display the data "distorted" or "skewed". I tried the tip from bj (9/9/2005 4:44 AM PST, to the question "Line chart or scatter chart??") there can be two x axis in a scatter chart. first select one of the data series and <axis select secondary next in <chart<chart options<axis select secondary x axis. by duplicating the data. But I could not find any possibility to enable the "second category (x) axis", it stays disabeld even with two data series. (I'm using Excel 2003.) -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
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 | |||
How do I make the Y axis in an excel chart the category 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 |