LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1,814
Default Need chart of 1 data set plotted against another similar data set

I have been unable to get a chart of data similar to below
Set1 Set2
73.3 74.9
78.8 74.7
80.6 75.5
85.5 76.4
89 79.6
90.2 97.5
94.1 96.0
I keep getting
point 1 against 73.3

Hovering over one of the points on a chart, I get a popup like "Series 1
Point "78.8" (22,74.7) and I really want to get a plot of 78.8 against 74.7.
A straight line trend should run at roughly 45degrees.
Thought I had it but adding data gave me the above problem
Help Please
Steve
point 2 against 78.8 etc

p
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Extra data plotted on chart Dan Charts and Charting in Excel 2 November 29th 07 01:34 PM
How to return the address of the range of plotted data on an XY scatter chart? Ken Johnson Charts and Charting in Excel 5 July 4th 06 12:40 PM
How do I stop plotted data from going to zero in a line chart? Dozier Charts and Charting in Excel 4 August 19th 05 07:11 PM
Help with data not getting plotted Scott Ehrlich Excel Discussion (Misc queries) 2 January 25th 05 05:17 AM
Help with data not getting plotted Scott Ehrlich Charts and Charting in Excel 1 January 23rd 05 05:15 PM


All times are GMT +1. The time now is 06:02 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"