Best way to create a chart w/ xy axis, quartile circles and point plots?


J

Jennlax27iga0

I am looking to create a chart with an x-y axis where each quadran
represents a different category (to receive a rating). There should b
four concentric circles representing the quartiles (so th
circles/borders would represent 25%, 50%, 75% 100%). I have a chart tha
calculates provider ratings for each category and in what quartile (wha
exact %) they fall. I want to put this all together to get an overal
picture, but am unsure of the most direct/easiest way to do so.

I have attached an image I drew that is basically what I am looking t
create in an Excel chart- I'm happy to answer any questions if this i
unclear. Any help much appreciated

+-------------------------------------------------------------------
|Filename: ChartExample1.jpg
|Download: http://www.excelbanter.com/attachment.php?attachmentid=302
+-------------------------------------------------------------------
 
Ad

Advertisements

T

the.christies

I am looking to create a chart with an x-y axis where each quadrant
represents a different category (to receive a rating). There should be
four concentric circles representing the quartiles (so the
circles/borders would represent 25%, 50%, 75% 100%). I have a chart that
calculates provider ratings for each category and in what quartile (what
exact %) they fall. I want to put this all together to get an overall
picture, but am unsure of the most direct/easiest way to do so.

I have attached an image I drew that is basically what I am looking to
create in an Excel chart- I'm happy to answer any questions if this is
unclear. Any help much appreciated!


+-------------------------------------------------------------------+
|Filename: ChartExample1.jpg |
|Download: http://www.excelbanter.com/attachment.php?attachmentid=302|
+-------------------------------------------------------------------+

One way would be to make an image of the circles and Categories in a drawing program like Paint.Net and set it as the Format Plot Area - Fill. Then set your axes to go through the middle of it.
xt
 
Ad

Advertisements

T

the.christies

One way would be to make an image of the circles and Categories in a drawing program like Paint.Net and set it as the Format Plot Area - Fill. Then set your axes to go through the middle of it.
xt





One way would be to make an image of the circles and Categories in a drawing program like Paint.Net and set it as the Format Plot Area - Fill. Then set your axes to go through the middle of it.
xt





One way would be to make an image of the circles and Categories in a drawing program like Paint.Net and set it as the Format Plot Area - Fill. Then set your axes to go through the middle of it.
xt





One way would be to make an image of the circles and Categories in a drawing program like Paint.Net and set it as the Format Plot Area - Fill. Then set your axes to go through the middle of it.
xt





One way would be to make an image of the circles and Categories in a drawing program like Paint.Net and set it as the Format Plot Area - Fill. Then set your axes to go through the middle of it.
xt





One way would be to make an image of the circles and Categories in a drawing program like Paint.Net and set it as the Format Plot Area - Fill. Then set your axes to go through the middle of it.
xt





One way would be to make an image of the circles and Categories in a drawing program like Paint.Net and set it as the Format Plot Area - Fill. Then set your axes to go through the middle of it.
xt





One way would be to make an image of the circles and Categories in a drawing program like Paint.Net and set it as the Format Plot Area - Fill. Then set your axes to go through the middle of it.
xt





One way would be to make an image of the circles and Categories in a drawing program like Paint.Net and set it as the Format Plot Area - Fill. Then set your axes to go through the middle of it.
xt





One way would be to make an image of the circles and Categories in a drawing program like Paint.Net and set it as the Format Plot Area - Fill. Then set your axes to go through the middle of it.
xt





One way would be to make an image of the circles and Categories in a drawing program like Paint.Net and set it as the Format Plot Area - Fill. Then set your axes to go through the middle of it.
xt
I've put an example at http://www.mediafire.com/?6wmg88htqf9twjz using a polar chart I had hanging around xt
 

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