Chart with Quadrants

 
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Charting RSS
Next:  Can a dropdown list option add color/time to a ra..  
Author Message
JICDB
External


Since: Jul 20, 2006
Posts: 28



PostPosted: Thu Mar 22, 2007 1:53 pm    Post subject: Chart with Quadrants
Archived from groups: microsoft>public>excel>charting (more info?)

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!
Back to top
David Biddulph
External


Since: Feb 24, 2007
Posts: 1373



PostPosted: Thu Mar 22, 2007 7:05 pm    Post subject: Re: Chart with Quadrants [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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!
Back to top
JICDB
External


Since: Jul 20, 2006
Posts: 28



PostPosted: Thu Mar 22, 2007 7:05 pm    Post subject: Re: Chart with Quadrants [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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!
>
>
>
Back to top
Del Cotter
External


Since: Apr 28, 2004
Posts: 256



PostPosted: Thu Mar 22, 2007 9:06 pm    Post subject: Re: Chart with Quadrants [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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@branta.demon.co.uk,
which goes to a spam folder-- please send your email to del3 instead.
Back to top
Display posts from previous:   
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Charting All times are: Eastern Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Warning: fopen(): open_basedir restriction in effect. File(/home/adsense_reject.txt) is not within the allowed path(s): (/home/helploc:/usr/lib/php:/usr/local/lib/php:/tmp) in /home/helploc/public_html/Giga/GigaFunctions.php on line 1144

Warning: fopen(/home/adsense_reject.txt): failed to open stream: Operation not permitted in /home/helploc/public_html/Giga/GigaFunctions.php on line 1144

Warning: fwrite() expects parameter 1 to be resource, boolean given in /home/helploc/public_html/Giga/GigaFunctions.php on line 1145

Warning: fclose() expects parameter 1 to be resource, boolean given in /home/helploc/public_html/Giga/GigaFunctions.php on line 1146