Subset Charts

  • Thread starter Thread starter DL
  • Start date Start date
D

DL

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
 
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
 
DL said:
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).
Click to expand...

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
 
Back
Top