Graphing in EXCEL


C

ConfusedJulie

I have a question to do with graphs. For example here is my data

1 apple
1 banana
1 grape
2 orange
2 grape
3 banana

and I want EXCEL to graph it exactly this way (See below) (with the data
labels included) (sort of like a scatterplot but not quite)

X orange
X apple
X banana Xbanana
X grape Xgrape
..........................................................
1 2 3

How do I do this? Please please answer my question. Thanks a lot in advance!
If I cant do this in excel, is there anything else you recommend or an addin
which is available online.

Thanks so much

Julie
 
Ad

Advertisements

B

Bernie Deitrick

Julie,

We'll try to get you un-confused ;-)

First, you need to download Rob Bovey's Cahrt Labeler add-in, found at:

http://www.appspro.com/Utilities/ChartLabeler.htm

Then, you need to make a table like

X Value Y Value Label
1 3 Apple
1 2 Banana
1 1 Grape
2 4 Orange
2 1 Grape
3 2 Banana

Then select the first two columns, and insert an XY chart, and then set the line to None and your
markers to whatever you want. (Right click on the line and choose "Format Data Series....")

Then when that is done, use Tools / XY Chart Labels and then Add Chart Labels, and selec the
label column cells through the dialog.

HTH,
Bernie
MS Excel MVP
 

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

excell 2003 graphs 2
Excel Bar Graph 1
graphing 1
Excel sheet for workout jogging time and graph 1
Graph Range 2
line graphs 1
Distribution Graph 1
Bar Graph 5

Top