Thread: [SOLVED] 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.)

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

To plot one data set against 2 y-axis, see the link
'Singe chart with dual axis' in
Excel Tips
http://www.tushar-mehta.com/excel/tips/index.html


--
Regards,

Tushar Mehta
www.tushar-mehta.com
Multi-disciplinary business expertise
+ Technology skills
= Optimal solution to your business problem
Recipient Microsoft MVP award 2000-2005

In article <38C45A64-255C-44CB-8AAA-CF855BA5047F@microsoft.com>, =?Utf-
8?B?S2lubm8gS2F0YW5h?= <Kinno Katana@discussions.microsoft.com> says...
> 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.)
>