Scatter Graph Help

  • Thread starter Thread starter Ket
  • Start date Start date
K

Ket

Dear All,

I believe I have a simple problem however am puzzled as to how to
achieve my end result.

I have three sets of data.

Delegate Name John Steve Brian Stacy
Potential 6 7 8 9
Value 7 8 9 7

I need to produce a scatter graph that plots the 'Potential Heading'
values against the x axis and the 'Value Headings' against the y axis.

Each time I try, both values are plotted against the y axis.

Any help greatly appreciated.

Thanks

Ket
(PS I am using excel 2K on Windows 2K)
 
Ket -

You must select the bottom two rows of your data, then select an XY
Scatter chart type in the Chart Wizard, not a Line chart type.

If you want the Delegate names to highlight each point, download one of
the following free addins, which enable this feature which Excel doesn't
to automatically:

Rob Bovey's Chart Labeler, http://appspro.com
John Walkenbach's Chart Tools, http://j-walk.com

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Back
Top