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