Very cool Del! I really like the Spot Matrix. All answers were helpful,
this one gives me a new look that I will use right away.
Regards,
Trouvera
"Del Cotter" wrote:
On Tue, 6 Feb 2007, in microsoft.public.excel.charting,
Del Cotter said:
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".
Here's an example of the data above formatted for a dot plot and for
bubbles.
http://www.branta.demon.co.uk/excel/...spotmatrix.xls
--
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.