Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Best way to create a chart w/ xy axis, quartile circles and point plots?
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! |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Best way to create a chart w/ xy axis, quartile circles and point plots?
On Friday, March 2, 2012 7:56:51 AM UTC+13, Jennlax27iga0 wrote:
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| +-------------------------------------------------------------------+ -- Jennlax27iga0 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 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Best way to create a chart w/ xy axis, quartile circles and point plots?
On Friday, March 2, 2012 8:53:57 AM UTC+13, wrote:
On Friday, March 2, 2012 7:56:51 AM UTC+13, Jennlax27iga0 wrote: 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| +-------------------------------------------------------------------+ -- Jennlax27iga0 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 On Friday, March 2, 2012 8:53:57 AM UTC+13, wrote: On Friday, March 2, 2012 7:56:51 AM UTC+13, Jennlax27iga0 wrote: 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| +-------------------------------------------------------------------+ -- Jennlax27iga0 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 On Friday, March 2, 2012 8:53:57 AM UTC+13, wrote: On Friday, March 2, 2012 7:56:51 AM UTC+13, Jennlax27iga0 wrote: 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| +-------------------------------------------------------------------+ -- Jennlax27iga0 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 On Friday, March 2, 2012 8:53:57 AM UTC+13, wrote: On Friday, March 2, 2012 7:56:51 AM UTC+13, Jennlax27iga0 wrote: 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| +-------------------------------------------------------------------+ -- Jennlax27iga0 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 On Friday, March 2, 2012 8:53:57 AM UTC+13, wrote: On Friday, March 2, 2012 7:56:51 AM UTC+13, Jennlax27iga0 wrote: 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| +-------------------------------------------------------------------+ -- Jennlax27iga0 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 On Friday, March 2, 2012 8:53:57 AM UTC+13, wrote: On Friday, March 2, 2012 7:56:51 AM UTC+13, Jennlax27iga0 wrote: 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| +-------------------------------------------------------------------+ -- Jennlax27iga0 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 On Friday, March 2, 2012 8:53:57 AM UTC+13, wrote: On Friday, March 2, 2012 7:56:51 AM UTC+13, Jennlax27iga0 wrote: 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| +-------------------------------------------------------------------+ -- Jennlax27iga0 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 On Friday, March 2, 2012 8:53:57 AM UTC+13, wrote: On Friday, March 2, 2012 7:56:51 AM UTC+13, Jennlax27iga0 wrote: 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| +-------------------------------------------------------------------+ -- Jennlax27iga0 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 On Friday, March 2, 2012 8:53:57 AM UTC+13, wrote: On Friday, March 2, 2012 7:56:51 AM UTC+13, Jennlax27iga0 wrote: 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| +-------------------------------------------------------------------+ -- Jennlax27iga0 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 On Friday, March 2, 2012 8:53:57 AM UTC+13, wrote: On Friday, March 2, 2012 7:56:51 AM UTC+13, Jennlax27iga0 wrote: 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| +-------------------------------------------------------------------+ -- Jennlax27iga0 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 On Friday, March 2, 2012 8:53:57 AM UTC+13, wrote: On Friday, March 2, 2012 7:56:51 AM UTC+13, Jennlax27iga0 wrote: 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| +-------------------------------------------------------------------+ -- Jennlax27iga0 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding second data point on primary axis of two axis chart | Charts and Charting in Excel | |||
Excel 2003 chart plots wierd on Excel 2007, time value x-axis | Excel Discussion (Misc queries) | |||
create a spider chart that plots like a compass | Charts and Charting in Excel | |||
How can you create Box Plots (Box-and-Whisker Plots) in Excel? | Charts and Charting in Excel | |||
Height (in points) of data point in chart above x-axis | Charts and Charting in Excel |