Hi all,
I am working towards automating the color of excel chart areas based on value of a column in additional to the value column.
For example, in the attachment where column B says 'work' the chart colour should be grey (for example), and when it says 'rest' the corresponding area should have a different color.
Is there a way I can automate this?
Bookmarks