Hi,
Somebody has asked me to prepare a bar chart showing weekly progress of some KPI. The chart covers an entire year and when a new week starts there would be a new bar. They wanted that bar to be of a different color than the rest. Once that week ends, that bar would become colored the same way as the rest and the new week would have a new bar colored differently.
I don't really know of any excel standard features allowing this, but I'm not very good with charts. Is VBA my only option?
Thanks for your help.
V.G.
Bookmarks