Fraserkitchell
New Member
- Joined
- May 21, 2010
- Messages
- 47
Hi There,
I have a column chart that I'm going to be updating every month. It shows a customer their daily usage of electricity or gas usage, and I want to put the weekends in a different color than the weekdays.
Problem is that I need a way to have the colors in the bars format themselves based on whether or not they reflect a weekday/weekend usage. Without this automatic formatting, every month and every chart (not to mention many, many more customers...
) would require manually recalculating the color scheme. That makes the goal infeasible.
I think this is going to take some VBA because I can't find anything online for this specific question that doesnt involve some special data range setup (ie: putting weekends in one column, weekdays in another). For the size of the sheets I'm working with, I hesistate to move to this method.
Thanks for the help!
fraser
I have a column chart that I'm going to be updating every month. It shows a customer their daily usage of electricity or gas usage, and I want to put the weekends in a different color than the weekdays.
Problem is that I need a way to have the colors in the bars format themselves based on whether or not they reflect a weekday/weekend usage. Without this automatic formatting, every month and every chart (not to mention many, many more customers...
) would require manually recalculating the color scheme. That makes the goal infeasible.I think this is going to take some VBA because I can't find anything online for this specific question that doesnt involve some special data range setup (ie: putting weekends in one column, weekdays in another). For the size of the sheets I'm working with, I hesistate to move to this method.
Thanks for the help!
fraser
