Chart with Quadrants

JICDB · External Since: Jul 20, 2006 Posts: 28

I need to produce a chart and I don't know the name of it so that I can
search Jon's Excel graph site and get info here. Any help would be
appreciated.

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.

I located the instructions from Jon on how to color the quadrants. Any idea
what this type of graph might be called so that I can see if someone else
here had this problem? And last but not least, anybody know how to go about
producing this type of graph. Thanks!

David Biddulph · External Since: Feb 24, 2007 Posts: 1373

It's an XY graph, with scales set appropriately.
--
David Biddulph

"JICDB" wrote in message

>I need to produce a chart and I don't know the name of it so that I can
> search Jon's Excel graph site and get info here. Any help would be
> appreciated.
>
> 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.
>
> I located the instructions from Jon on how to color the quadrants. Any
> idea
> what this type of graph might be called so that I can see if someone else
> here had this problem? And last but not least, anybody know how to go
> about
> producing this type of graph. Thanks!

JICDB · External Since: Jul 20, 2006 Posts: 28

Thanks! I'll see what I can find here to help.

"David Biddulph" wrote:

> It's an XY graph, with scales set appropriately.
> --
> David Biddulph
>
> "JICDB" wrote in message
>
> >I need to produce a chart and I don't know the name of it so that I can
> > search Jon's Excel graph site and get info here. Any help would be
> > appreciated.
> >
> > 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.
> >
> > I located the instructions from Jon on how to color the quadrants. Any
> > idea
> > what this type of graph might be called so that I can see if someone else
> > here had this problem? And last but not least, anybody know how to go
> > about
> > producing this type of graph. Thanks!
>
>
>

Del Cotter · External Since: Apr 28, 2004 Posts: 256

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 del.RemoveThis@branta.demon.co.uk,
which goes to a spam folder-- please send your email to del3 instead.