Scatter chart Indicator size
 

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?

Scatter chart Indicator size
 

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/ChartsH...omMarkers.html

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Joshua Jean" <Joshua wrote in message
...
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?

Scatter chart Indicator size
 

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

"Andy Pope" wrote:

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/ChartsH...omMarkers.html

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Joshua Jean" <Joshua wrote in message
...
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?