Line Chart Format change on select

I have a xy scatter chart with 5 series. Is it possible to have the line
thickness dynamically change when selected? An example is, if you click on a
line you can use the up and down arrows to cycle threw the different parts of
the chart. When scrolling I would like the thickness to change, while select,
and when I go to the next line return to standard formatting.

I know this sound a little out there, but just trying to make the boss
happy. Thank you for your help.

Tim

Hi,

If you want it to happen directly in the chart you will need event code.

If you want to use a control to select which line to hilite then have a
read of Jon blog,
http://peltiertech.com/WordPress/200...le-line-chart/

Cheers
Andy

tpeter wrote:
I have a xy scatter chart with 5 series. Is it possible to have the line
thickness dynamically change when selected? An example is, if you click on a
line you can use the up and down arrows to cycle threw the different parts of
the chart. When scrolling I would like the thickness to change, while select,
and when I go to the next line return to standard formatting.

I know this sound a little out there, but just trying to make the boss
happy. Thank you for your help.

Tim

--

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

Andy,

Thank you for the response, I haven't tried it yet but looking at the
examples that was exacty what I was talking about. Thanks again for your help.

"Andy Pope" wrote:

Hi,

If you want it to happen directly in the chart you will need event code.

If you want to use a control to select which line to hilite then have a
read of Jon blog,
http://peltiertech.com/WordPress/200...le-line-chart/

Cheers
Andy

tpeter wrote:
I have a xy scatter chart with 5 series. Is it possible to have the line
thickness dynamically change when selected? An example is, if you click on a
line you can use the up and down arrows to cycle threw the different parts of
the chart. When scrolling I would like the thickness to change, while select,
and when I go to the next line return to standard formatting.

I know this sound a little out there, but just trying to make the boss
happy. Thank you for your help.

Tim

--

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