ShelleyBelly
New Member
- Joined
- Mar 2, 2011
- Messages
- 44
Hi All
I have a stacked bar chart which takes it's data from an array. I would however like to to set the data labels for all data series to a identical array of exactly the same size located below the original. I have had a look a the XY Chart Labeler by Rob Bovey which in essence does the trick for each series. But my chart may have up to 200 series!
Does anyone know of a similar VBA solution to XY Chart Labeler, but which does bulk Data Label changes?
Many thanks in advance,
Tom
I have a stacked bar chart which takes it's data from an array. I would however like to to set the data labels for all data series to a identical array of exactly the same size located below the original. I have had a look a the XY Chart Labeler by Rob Bovey which in essence does the trick for each series. But my chart may have up to 200 series!
Does anyone know of a similar VBA solution to XY Chart Labeler, but which does bulk Data Label changes?
Many thanks in advance,
Tom