Change the color of the last bar in a bar chart

bigjaker

New Member
Joined
Mar 22, 2005
Messages
46
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
 

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

Forum statistics

Threads
1,213,510
Messages
6,114,048
Members
448,543
Latest member
MartinLarkin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top