Monday, 26 September 2016

How Can I Fix - Delete Chart Series with toggle button?

Delete Chart Series with toggle button

Hello,I have the following code, each sub is called by a toggle button (3 in total) on on a sheet.I would like to toggle the series on and off by pressing each toggle button .So for the first sub, SingleChart, pressing the toggle button tglSingle puts 3 series in 3 different charts (Life,Year,Month).Pressing the toggle again would delete the 3 series.How can I do that?Also, is there a way to write a more elegant code as a lot of lines are repeated throughout?Thanks

Anwsers to the Problem Delete Chart Series with toggle button

I suppose one method you could try would be to put a marker value in a hidden column to store whether the toggle is in the 'on' or 'off' position, you could then check for the value in that cell and add or delete the series depending on its value, updating the value in the hidden cell to denote the new situation.

Access the files on your computer via MY COMPUTER

Under the C: drive, access the WINDOWS folder

Select the SOFTWARE DISTRIBUTION folder, followed by the DOWNLOAD folder.

Delete any files within this download folder.

If you are unable to delete these files, open the command prompt (CMD) as the administrator, and type "net stop wuauserv" into the CMD prompt window. Press ENTER. This should allow you to delete the files from step 4.

Once the files are deleted, open and run the CMD as the administrator and type "wuauclt.exe /updatenow". Press ENTER.

Recommended Method to Repair the Problem: Delete Chart Series with toggle button:

How to Fix Delete Chart Series with toggle button with SmartPCFixer?

1. Click the button to download SmartPCFixer . Install it on your computer. Run it, and it will scan your computer. The junk files will be shown in the scan result.

2. After the scan is finished, you can see the errors and problems need to be repaired. Click Fix All.

3. When the Fixing part is done, your computer has been speeded up and the errors have been fixed