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

On Tue, 3 Jul 2007, in microsoft.public.excel.charting,
ConfusedJulie said:

I want EXCEL to graph 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?

Set your data up like this:

Y labels
1 3 apple
1 2 banana
1 1 grape
2 4 orange
2 1 grape
3 2 banana

Then make an XY(Scatter) graph from THE FIRST TWO COLUMNS ONLY.

Finally, download and install the AppsPro XY Chart Labeler, an Excel
add-in from Rob Bovey:

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

and use it to label the points in the XY graph you made with the words
in the third column.

--
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.

It works! Thanks a lot Del!

"Del Cotter" wrote:

On Tue, 3 Jul 2007, in microsoft.public.excel.charting,
ConfusedJulie said:

I want EXCEL to graph 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?

Set your data up like this:

Y labels
1 3 apple
1 2 banana
1 1 grape
2 4 orange
2 1 grape
3 2 banana

Then make an XY(Scatter) graph from THE FIRST TWO COLUMNS ONLY.

Finally, download and install the AppsPro XY Chart Labeler, an Excel
add-in from Rob Bovey:

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

and use it to label the points in the XY graph you made with the words
in the third column.

--
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.

On Thu, 5 Jul 2007, in microsoft.public.excel.charting,
ConfusedJulie said:
It works! Thanks a lot Del!

You're welcome, and thanks for the feedback. Some people we never hear
from again.

--
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.