Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 91
Default Chart with Quadrants

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!
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 8,651
Default Chart with Quadrants

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!



  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 91
Default Chart with Quadrants

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!




  #4   Report Post  
Posted to microsoft.public.excel.charting
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.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 error "some chart types cannot be combined with other chart types. Select a different chart types" roadsidetree Charts and Charting in Excel 15 June 2nd 09 10:53 AM
Double-stacked Bar Chart WITH a Secondary Y Axis Line chart? lpenndorf Charts and Charting in Excel 1 February 7th 07 05:32 PM
Huge differences in chart values screws my bar chart scale up. Sirritys Charts and Charting in Excel 2 June 13th 06 10:33 AM
Freeze panes just splits my page into quadrants [email protected] Excel Discussion (Misc queries) 5 March 8th 06 08:49 PM
How do I set a circle to be filled in quadrants? cburnham564 Excel Discussion (Misc queries) 0 November 17th 05 06:30 PM


All times are GMT +1. The time now is 09:21 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"