velohead
Board Regular
- Joined
- Aug 22, 2007
- Messages
- 212
Hi All,
I have a stacked bar chart with 15 items, eg apples, oranges, lemons, limes etc.
For each of those I have two bars, say actual and budget.
Each of those bars (30 of them 15x2=30) has 12 segments, for the 12 months of the year.
I just need a simple macro to select say segment 2 of bar 2 (being Apples/Actuals) and amend the colour.
I would then have to repeat for bar 4, bar 6, bar 8 up to bar 30. Manually repetitious, with VBA a breeze.
Once I have solved that I can augment the macro to select any segment of any bar to change the colour.
To be honest, I find selecting a particular segment manually as extremely hit and miss on this stacked bar charts.
Hope there is a VB solution, thanks all.
I have a stacked bar chart with 15 items, eg apples, oranges, lemons, limes etc.
For each of those I have two bars, say actual and budget.
Each of those bars (30 of them 15x2=30) has 12 segments, for the 12 months of the year.
I just need a simple macro to select say segment 2 of bar 2 (being Apples/Actuals) and amend the colour.
I would then have to repeat for bar 4, bar 6, bar 8 up to bar 30. Manually repetitious, with VBA a breeze.
Once I have solved that I can augment the macro to select any segment of any bar to change the colour.
To be honest, I find selecting a particular segment manually as extremely hit and miss on this stacked bar charts.
Hope there is a VB solution, thanks all.
