Hi
I'm creating a waterfall chart in Excel 2016 and would like to know how to do two things, please:
1) to re-set the bars so they all start from zero eg at the moment, I have a bar which has the value 123 ie 123 instances occurred in this particular instance. But it goes from 150 on the chart up to 273 (150 + 123). But I want it to start from 0 and go up to 150.
2) change the colours of each bar (there are 5, in total). So that one is always red, one is always blue, etc.
Does anyone know how to do this?
Thanks in advance.
I'm creating a waterfall chart in Excel 2016 and would like to know how to do two things, please:
1) to re-set the bars so they all start from zero eg at the moment, I have a bar which has the value 123 ie 123 instances occurred in this particular instance. But it goes from 150 on the chart up to 273 (150 + 123). But I want it to start from 0 and go up to 150.
2) change the colours of each bar (there are 5, in total). So that one is always red, one is always blue, etc.
Does anyone know how to do this?
Thanks in advance.
