Re: Chart with Quadrants
- From: Del Cotter <del@xxxxxxxxxxxxxxxxxx>
- Date: Thu, 22 Mar 2007 19:32:30 +0000
On Thu, 22 Mar 2007, in microsoft.public.excel.charting,
JICDB <JICDB@xxxxxxxxxxxxxxxxxxxxxxxxx> 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 del@xxxxxxxxxxxxxxxxxx,
which goes to a spam folder-- please send your email to del3 instead.
.
- Prev by Date: Re: Shading a portion of the space between two lines
- Next by Date: Clustered line and bar on two axes
- Previous by thread: Re: Chart with Quadrants
- Next by thread: Re: Format Individual Grid Lines
- Index(es):
Relevant Pages
|
