PC Review


Reply
Thread Tools Rate Thread

Chart with differing x axis

 
 
Anthony Blackburn
Guest
Posts: n/a
 
      17th May 2010
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?
 
Reply With Quote
 
 
 
 
Mike Middleton
Guest
Posts: n/a
 
      18th May 2010
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" <(E-Mail Removed)> wrote in
message news:99B48661-377A-4424-A37B-(E-Mail Removed)...
> 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?


 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
TO CREATE A LINE CHART WITH RATE IN Y AXIS & REAL TIME IN X AXIS =?Utf-8?B?dmlqYWljYmU=?= Microsoft Excel Charting 4 9th Nov 2006 10:16 AM
How to place a secondary y axis bar in a bar chart next to two primary y axis bars? Dmitry Microsoft Excel Discussion 1 4th May 2006 01:58 AM
How to place a secondary y axis bar in a bar chart next to two primary y axis bars? Dmitry Microsoft Excel Charting 2 4th May 2006 01:58 AM
Chart two variables with differing values =?Utf-8?B?RGFu?= Microsoft Excel Charting 2 23rd Jan 2006 07:07 PM
Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis mw210461@yahoo.com Microsoft Excel Charting 0 13th Jul 2005 09:30 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:00 PM.