Chart with Quadrants

G

Guest

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!
 
D

Del Cotter

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top