Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting multiple charts on a single sheet
Hi,
Thanks in advance for the help with some code I've tried to write. I have people entering data on a sheet. They then click a check box and excel will take the data and put it into a chart. There are 10 lines of data avaible to create 10 chart on a designated sheet. My code worked ok until we were upgrated to v.2007. It will go though and delete the charts but loop back through (I'm guessing) and locks up at the ActiveSheet.ChartObjects.Delete There are two problems I would like to fix. 1. Fix the code so it wont lock up if it does not find a chart to delete. 2. Only Delete charts that are wanting to be redrawn. Sheets("XSection 1-10").Select NumSeries = Worksheets("Survey").Range("BV50").Value For Counter = 1 To NumSeries ActiveSheet.ChartObjects.Delete Next Counter NumSeries = 0 'XSection 9 If Sheets("Survey").Range("BV9") = True Then Charts.Add ActiveChart.ChartArea.Select (this goes on to create the new chart) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to display multiple charts on a single chart sheet | Charts and Charting in Excel | |||
multiple charts from a single pivot table | Charts and Charting in Excel | |||
deleting multiple === signs to get single = | Excel Discussion (Misc queries) | |||
Multiple charts on single chart sheet | Charts and Charting in Excel | |||
Deleting charts on a sheet | Excel Programming |