Scatter graph in Excel 2007

H

Hubes

Here is what I am trying do and not sure if it can be done or not. I have 3
columns of data. Column A is the data that I want plotted. Column B is to be
my X-axis and Column C is to be my Y-Axis. When I create the scatter graph it
is not coming out like that and not sure what I need to do to correct things.

If it helps out any Column A is a question number
Column B is Quality of the question
Column C is Importance of the question.

Thanks for any help you guys can give.
 
J

Jon Peltier

Do you mean the question number is a label to be applied to the data that is
plotted? Select columns B and C and create your XY chart, then use one of
these free Excel add-ins to assign the labels in column A to the data points
you just plotted:

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

- Jon
 

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

Top