Forum Discussion

Copper Contributor

Sep 18, 2019

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 no...

Diamond Contributor

Sep 18, 2019

Hi,

Double click on Total data point and Set it as total

michaelFoug
Copper Contributor
Sep 19, 2019
SergeiBaklan
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
- SergeiBaklan
  Diamond Contributor
  Sep 19, 2019
  michaelFoug
  
  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
  
  Classeur 23.xlsx20 KB
  - SergeiBaklan
    Diamond Contributor
    Sep 19, 2019
    SergeiBaklan
    
    And finally I'm very sorry, I missed you asked for Excel Online. Will check if possible to total in it.

Resources