Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Need chart of 1 data set plotted against another similar data set
On Fri, 25 Apr 2008, in microsoft.public.excel.charting,
Steve said: 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 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. Temporarily remove the label "Set 1" above the first column, leaving a blank notch in the rectangle of cells. This clues Excel in that you'd like the column below the blank to be the X axis, and the row to the right of the blank to be the labels. You can put the label back in when you're done making the chart. -- Del Cotter NB Personal replies to this post will send email to , which goes to a spam folder-- please send your email to del3 instead. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Need chart of 1 data set plotted against another similar data set
Make an XY chart.
- Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Steve" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extra data plotted on chart | Charts and Charting in Excel | |||
How to return the address of the range of plotted data on an XY scatter chart? | Charts and Charting in Excel | |||
How do I stop plotted data from going to zero in a line chart? | Charts and Charting in Excel | |||
Help with data not getting plotted | Excel Discussion (Misc queries) | |||
Help with data not getting plotted | Charts and Charting in Excel |