XY scatter plot

  • Thread starter Thread starter JayK
  • Start date Start date
J

JayK

Hi,

I have data in 3 columns as follows:
First column is the category
Second column is X value
Third column is Y value.

Now I want to draw an XY scatter plot with X & Y values, with the categories
in column A as legends/labels.

How do I do it? Excel creates 2 series instead :(
 
Select the numerical columns (B & C) and make your XY chart. Use one of
these two free utilities to add the labels range as labels to the chart:

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

- Jon
 
This would be useful for me.
I downloaded one of the suggested free utilities.
I created a sample chart but do not know how to invoke the utility.
Any suggestions?
thanks
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

xy scatter graph 0
problem with scatter diagram excel 2007 2
Multiple XY pairs in scatter plot Excel 2007 2
How do I adjust marker spacing in Excel scatter plot? 1
XY scatter plot with more than 32000 rows in Excel 2003 0
Excel 2007: Default Chart Template 2
XY Scatter Plot Chart - URGENT HELP 1
In excel scatter plot with 2 series, how do I connect xy coordinat 2

Back
Top