| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Line Chart Format change on select
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 |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Line Chart Format change on select
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to change bar to line in line-column on 2 axes chart in Excel2 | Charts and Charting in Excel | |||
| Format change when user select a Factor on drop down box | Excel Worksheet Functions | |||
| xy plot line style change when I select "fixed maximum" | Charts and Charting in Excel | |||
| change last serie to be line in the line-column Excel chart in Wor | Charts and Charting in Excel | |||
| Make a line in a bar chart, and change color of any bars that exceed the line | Excel Discussion (Misc queries) | |||
Hybrid Mode
