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).

[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).

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).

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