Forum Discussion
Excel Web chart Waterfall
Hey,
I have Excel Web Office365 and wanted to use Waterfall Chart
but i have 3 categories automatically detect :
increase (blue),
decrease (orange)
and total (grey).
But the last Total, did not.
i don't know where to parameter...
Thank you !
7 Replies
Select last column, right click menu, format data point, check set as total
it goes to
Here you may select any color you wish, e.g. grey
If you are Ok to use https://appsource.microsoft.com/en-us/product/office/wa104380662?tab=overview. https://www.youtube.com/watch?v=efMDkWUVnEg&t=3s might help you to create an advanced Waterfall Chart in Microsoft Excel 365 online.
ThankYou,
But where do i have to click ? sorry i don't find it...
https://pochet-my.sharepoint.com/:x:/g/personal/mickael_fougeres_groupe-pochet_fr/Eba9E_GrxhxOsH5EIFxz4SsBVaBSmyXWk_V_w7pMiGFxvQ?e=YM5aC9
You are welcome.
First, that's for desktop version of Excel, I'm not sure that could be done in Excel Online.
Click on any column of your chart (better on right one) - data series will be selected
Now two variants. Click again on this column (single click), after that on ribbon select Format section and next click on Format selection
Another option just double click on this column.
In both cases right pane shall appear with options to format data point, here check Set as total
In brief, you shall select last data point and format it as total. Finally
