Chart Should work through VBA

  • I have been trying to find a code which highlight Gantt Chart, Remaining and Completed days through code. I have added three buttons and i want that when i press the Completed button then chart should highlight only for complete.

    If i press the Remaining it should highlight the remaining color

    If i press the both Button it should highlight both.

    Currently my Sheet is working through Conditional Formatting if you change the percentage it will work accordingly same thing i want from above buttons. I have tried to find this thing online but nothing is available. Any help will be greatly appreciated.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!