View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.charting
Del Cotter Del Cotter is offline
external usenet poster
 
Posts: 560
Default charting locations over time instead of numbers


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.