Hi all,

I currently have a stacked column chart with columns for each hour of the day on the chart. Each stack represents a product produced during that hour of the day. For different days of production, a new copy of the file will be used.

The source data is relatively dynamic with each series needing to be flexible enough to represent a new product (I'm dealing with an infinite list of product names here). As such, the series names reference cells which change it's values depending on calculations from another sheet. However, all products can be categorised into two groups: ones whose name has a "X-" in front of it and those which don't.

What I need to do is to be able to get excel to put a border around the stacks representing products whose name starts with the "X-" or use some other way of showing this difference (perhaps using a pattern works better).

I assume that I'll need to use a macro or VBA to do this. I have next to no VBA experience but have done Java and HTML programming before so it shouldn't be hard to pick it up.

Any help will be much appreciated.

Regards,
MugsyAU