View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope
 
Posts: n/a
Default Creating a chart of overlaid area circles?

Hi,

You could use a bubble chart. That takes 3 parameters x,y and size.
keep the x and y constant and adjust the size.

Cheers
Andy

m.nutt1 wrote:
Can anyone help?

I am trying to create a chart that contrasts size by laying 3 different
sized circles on top of each other (so it will basically look like a shooting
target). I know i can represent this data in other ways but this will have
greatest impact for the purpose.

Can Excel do this? And if so, how? - Please bear in mind I am not very techy
so the simpler the better!

Thanks very much


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info