On Mon, 5 Feb 2007, in microsoft.public.excel.charting,
Trouvera52 said:

I am trying to recreate a very cool chart with no luck. The chart has
categories on the Y-axis (think Key Purchase Criteria) with multiple
companies results in a (horizontal) line format (think Company A, B, C, D) on
the x-axis based on values (customer satisfaction) 1-9.

Category Company A Company B Company C
KPC 1 3 5 7
KPC 2 4 9 7
KPC 3 2 5 9

What you're describing is a "dot plot", which is to an Excel "line
chart" what the Excel "bar chart" is to an Excel "column chart".

Excel makes dot plots difficult because it has no built-in way of
providing a category vertical axis for line graphs: the vertical axis
can only ever be a value axis.

If you are only presenting this on paper or overhead transparencies, I
find a quick and dirty way of producing these is to make a simple line
chart and then format all the text so it reads sideways. You have to
tilt your head to read it on the screen when you're designing it, but
you can just turn the paper or transparency round when you present it to
your audience.

If you want it to look upright on screen, the design is trickier, but
still feasible: Jon Peltier, Kelly O'Day, Charley Kyd and other Excel
graph experts have instructions on making dot plots on their web sites.
Google "Excel dot-plot" for examples.

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