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?

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?

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?