hi all,
hopefully i can explain this well.
Basically looking to build a stacked chart for 5 years on the x-axis.
I want to stack each of the 12 months (y-axis) upwards with if each month was either red, amber or green.
So example for say 2015 year Jan, Apr, Jul, Oct = Green & Feb, May, Aug, Nov = Amber & Mar, Jun, Sep, Dec = Red
I want to show these 12 individual months with their respective colours rather than summing the colours.
Is this even possible?
many thanks
Bookmarks