If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Subset Charts
Is there any way to produce a "circle inside a circle"
chart that is proportioned correctly? I am using this to show core and fringe proportions of total employment (not a pie chart). |
#2
|
|||
|
|||
Subset Charts
[This followup was posted to microsoft.public.excel.charting with an email copy to DL.
Please use the newsgroup for further discussion.] Create a bubble chart with 2 points. Each point will have the same x and y values, but a bubble size that reflects whatever you want to plot. Format the chart to get the desired effect (remove axes, change the min/max values of the axes, etc.) -- Trouble finding replies to your posts? Use a newsreader. See the tutorial 'Outlook Express and Newsgroups' on my web site Regards, Tushar Mehta, MS MVP -- Excel www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , dleona1 @state.wy.us says... Is there any way to produce a "circle inside a circle" chart that is proportioned correctly? I am using this to show core and fringe proportions of total employment (not a pie chart). |
#3
|
|||
|
|||
Subset Charts
Is this something you could accomplish with a bubble chart? Align two
bubbles over each other (same X and Y), and hide whichever normal chart elements you want hidden. - Jon ------- Jon Peltier, Microsoft Excel MVP http://www.geocities.com/jonpeltier/Excel/index.html _______ DL wrote: Is there any way to produce a "circle inside a circle" chart that is proportioned correctly? I am using this to show core and fringe proportions of total employment (not a pie chart). |
#4
|
|||
|
|||
Subset Charts
DL wrote:
Is there any way to produce a "circle inside a circle" chart that is proportioned correctly? I am using this to show core and fringe proportions of total employment (not a pie chart). How about using a bubble chart? The location of each bubble would be the same, but the size of the bubble would vary based on your proportions. You might need a separate series for each concentric circle in order to overlay the circles properly. Then you might need to eliminate the axes, etc. depending on the desired appearance of the chart. I think the *area* of the bubble is related to the size parameter that you feed Excel. So bubbles of size 4 would have a diameter twice that of a bubble of size 1. (After 3 tries, I didn't explain that very well -- sorry.) Dave dvt at psu dot edu |
Thread Tools | |
Display Modes | |
|
|