I have a bunch of bar charts that need to be updated monthly or quarterly. I would like a quick easy way to update all of the charts when new data is added automatically. The far right bar needs to be an orange color as it is not a complete amount for the time frame.
An example would be we are in 2019 Quarter 2, Currently the 2019 Quarter 2 column should be the Orange color. When we start to add in the 2019 Quarter 3 data the 2019 Quarter 2 should revert back to the blue color and 2019 Quarter 3 should now be orange.
I would prefer to stay away from VBA for this one but if that is what I need to do I will do it.
I have about 90 charts that need to be updated so any help would be much appreciated.
Thank you
An example would be we are in 2019 Quarter 2, Currently the 2019 Quarter 2 column should be the Orange color. When we start to add in the 2019 Quarter 3 data the 2019 Quarter 2 should revert back to the blue color and 2019 Quarter 3 should now be orange.
I would prefer to stay away from VBA for this one but if that is what I need to do I will do it.
I have about 90 charts that need to be updated so any help would be much appreciated.
Thank you
