How do I add a second y-axis in an xy(Scatter) chart?

#1 10-26-2005, 04:05 AM

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 10-26-2005, 06:05 AM

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

#3 10-27-2005, 12:05 PM

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.)
>

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)