I'm testing 20 or so products across a range of benchmarks, each with its own graph. Creating the graphs is straightforward, but formatting colours etc seems to be very time consuming as there doesn't seem to be many ways to format several graphs at once.
The biggest issue is that every time I create new graphs, there is a single product or products that I want to highlight - in this case a bar chart - with different bar colours. At the moment I'm having to manually change the colour for every bar for that particular item in every graph. Is there any way to tell Excel that a particular product name in the data should have a specific colour for its bar in all the bar charts in a particular workbook?