ShelleyBelly
New Member
- Joined
- Mar 2, 2011
- Messages
- 44
Hello All,
I've written some VBA which turns an array into a stacked bar chart where series with the same name are coloured the same. However, having multiple series with the same name has led to a rather pointless legend with multiple duplicates. My main two questions are:
1) Is there a way to extract unique series names.
2) Is there a way to add each of these unique series names as individual dummy series which will have no values
The next step will be to remove the initial number of series which will then leave a legend with unique series names.
Many Thanks in advance,
Tom
I've written some VBA which turns an array into a stacked bar chart where series with the same name are coloured the same. However, having multiple series with the same name has led to a rather pointless legend with multiple duplicates. My main two questions are:
1) Is there a way to extract unique series names.
2) Is there a way to add each of these unique series names as individual dummy series which will have no values
The next step will be to remove the initial number of series which will then leave a legend with unique series names.
Many Thanks in advance,
Tom