Scatter chart Indicator size

[Guest]

I am trying to change the size of data indicators larger than the range
allows(2-72). I get as far as the format legend key window, but would like to
go bigger than 72 units. Has anyone dealt eith this before?

 

[Andy Pope]

Hi,

The only way around this would be to use VBA and custom markers.
You would need to set the size of the shape based on your data and then
copy/paste the shape to the appropriate data marker.

Here is a page explaining custom markers.
http://peltiertech.com/Excel/ChartsHowTo/CustomMarkers.html

Cheers
Andy

 

[Guest]

Thank you, That is exaclty the result I was looking for. I must have benn
trying to go the long way about it.