I forgot that Kelly uses a different combination. The bar chart axis labels
are sometimes more robust, particularly in that you often can get longer
text before Excel forces a line break.

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


"Del Cotter" wrote in message
...

On Sat, 17 Feb 2007, in microsoft.public.excel.charting,
Jon Peltier said:
I show how to make this kind of chart on my web site. Perhaps a different
set of words might help you get it:

http://peltiertech.com/Excel/Charts/DotPlot.html

But beware, that's not just a different set of words, but a slightly
different technique: Kelly's technique uses all XY series and a labelled
dummy series for the category Y-axis; Jon's technique uses a horizontal
bar chart series for the category Y-axis instead.

A third tutorial that I like (it's the one I learned dot plots on) is
Charley Kyd's at ExcelUser.com:

http://www.exceluser.com/dash/dotplot.htm

The technique here is similar to that in Jon's tutorial: horizontal bar
chart for the labels, XY series for the dots.

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