Prev: legend keeps changing
Next: selecting and viewing a range
From: Anthony Blackburn on 17 May 2010 18:13
I want to make a chart that has data from dis-similar x axis.

For example, I want to have a line graph for an x axis with a range of 50-100.
On the same chart, I want a line graph with an x axis that has a range of
90% to 110%.

How do I do this?
From: Mike Middleton on 17 May 2010 22:57
Anthony Blackburn -

Create an XY (Scatter) chart type with one data series (pairs of XY values).
Add the second data series to the chart. Then select one of the data series,
and choose to use a secondary axis. Adjust axis intercepts. For details,
describe your data and specify version of Excel.

- Mike Middleton
http://www.DecisionToolworks.com


"Anthony Blackburn" <AnthonyBlackburn(a)discussions.microsoft.com> wrote in
message news:99B48661-377A-4424-A37B-5C8EAAEC6EB9(a)microsoft.com...
> I want to make a chart that has data from dis-similar x axis.
>
> For example, I want to have a line graph for an x axis with a range of
> 50-100.
> On the same chart, I want a line graph with an x axis that has a range of
> 90% to 110%.
>
> How do I do this?

 | 
Pages: 1
Prev: legend keeps changing
Next: selecting and viewing a range