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.

    Files

    • Excel.xlsm

      (32.03 kB, downloaded 45 times, last: )