View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.charting
Del Cotter Del Cotter is offline
external usenet poster
 
Posts: 560
Default Chart with Quadrants

On Thu, 22 Mar 2007, in microsoft.public.excel.charting,
JICDB said:
I need a graph where the X and Y axis meet at zero in the middle of the
graph with positive and negatives numbers on both. My plan is to use this
chart to analyze data as to what quadrant it falls into, eg. Quadrant I would
be if the product was positive on the Y axis but negative on the X axis. Q2
= positive on Y, positive on X Q3 = negative y and negative Q4 negative y
and positive x.


Try googling for "BCG matrix" for examples of this kind of four quadrant
graph. "BCG" stands for Boston Consulting Group. There's an example on
Ed Ferrero's page:

http://www.edferrero.com/Charting.aspx

which not only has four quadrants, and bubbles for product size, but
also the bubbles are pie charts for some other quality of the product.

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