Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Chart automation problems!
Hi Folks,
I'm using an embedded Excel chart in an application which the user can change (via combo) what they want to graph. How do you reset the graph between selections? My original idea was simply to delete the graph and add a new one, but this produces an obtrusive dialog box. The other option I tried was to delete all the series from the series collection and then add new ones. This almost works, but when you come to insert new values in the series, Excel comes back with unable to set the value property? Also rather weirdly in Delphi at least, when my company upgraded to Office 2K, whenever an instance of Excel is created it seems to stop on a breakpoint within Excel?! Is this normal? -- Regards Rob Pollard My Astro CCD page is: http://www.robpol.demon.co.uk |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Chart automation problems!
Hi Rob,
You could set the visible property of the chart to FALSE when there is no selection. This way the graph would disappear until something is selected. tim "Rob Pollard" wrote in message ... Hi Folks, I'm using an embedded Excel chart in an application which the user can change (via combo) what they want to graph. How do you reset the graph between selections? My original idea was simply to delete the graph and add a new one, but this produces an obtrusive dialog box. The other option I tried was to delete all the series from the series collection and then add new ones. This almost works, but when you come to insert new values in the series, Excel comes back with unable to set the value property? Also rather weirdly in Delphi at least, when my company upgraded to Office 2K, whenever an instance of Excel is created it seems to stop on a breakpoint within Excel?! Is this normal? -- Regards Rob Pollard My Astro CCD page is: http://www.robpol.demon.co.uk |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
chart with color automation | Charts and Charting in Excel | |||
Chart automation with entry data | Charts and Charting in Excel | |||
Chart automation | Charts and Charting in Excel | |||
Automation of Dynamic Chart Title and legend changes | Charts and Charting in Excel | |||
Chart Automation | Charts and Charting in Excel |