Home

Excel Web chart Waterfall

%3CLINGO-SUB%20id%3D%22lingo-sub-861206%22%20slang%3D%22fr-FR%22%3EExcel%20Web%20Chart%20Waterfall%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-861206%22%20slang%3D%22fr-FR%22%3E%3CP%3EHey%3C%2FP%3E%3CP%3EI%20have%20Excel%20Web%20Office365%20and%20wanted%20to%20use%20Waterfall%20Chart%3C%2FP%3E%3CP%3E%26nbsp%3Bbut%20i%20have%203%20categories%20automatically%20detect%3A%3C%2FP%3E%3CP%3Eincrease%20(blue)%2C%3C%2FP%3E%3CP%3Edecrease%20(orange)%3C%2FP%3E%3CP%3Eand%20total%20(grey).%3C%2FP%3E%3CP%3EBut%20the%20last%20Total%2C%20did%20not.%3C%2FP%3E%3CP%3Ei%20don't%20know%20where%20to%20parameter...%3C%2FP%3E%3CP%3EThank%20you!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F132359i804C99AAB0EF7E7B%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22clipboard-image-0.png%22%20title%3D%22clipboard_image_0.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-861206%22%20slang%3D%22fr-FR%22%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-861285%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Web%20chart%20Waterfall%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-861285%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F411118%22%20target%3D%22_blank%22%3E%40michaelFoug%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHi%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EDouble%20click%20on%20Total%20data%20point%20and%20Set%20it%20as%20total%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20674px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F132363iCB929AA6D8FE60BA%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-862590%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Web%20chart%20Waterfall%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-862590%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThankYou%2C%3C%2FP%3E%3CP%3EBut%20where%20do%20i%20have%20to%20click%20%3F%20sorry%20i%20don't%20find%20it...%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fpochet-my.sharepoint.com%2F%3Ax%3A%2Fg%2Fpersonal%2Fmickael_fougeres_groupe-pochet_fr%2FEba9E_GrxhxOsH5EIFxz4SsBVaBSmyXWk_V_w7pMiGFxvQ%3Fe%3DYM5aC9%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fpochet-my.sharepoint.com%2F%3Ax%3A%2Fg%2Fpersonal%2Fmickael_fougeres_groupe-pochet_fr%2FEba9E_GrxhxOsH5EIFxz4SsBVaBSmyXWk_V_w7pMiGFxvQ%3Fe%3DYM5aC9%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-864011%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Web%20chart%20Waterfall%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-864011%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F411118%22%20target%3D%22_blank%22%3E%40michaelFoug%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20are%20welcome.%3C%2FP%3E%0A%3CP%3EFirst%2C%20that's%20for%20desktop%20version%20of%20Excel%2C%20I'm%20not%20sure%20that%20could%20be%20done%20in%20Excel%20Online.%3C%2FP%3E%0A%3CP%3EClick%20on%20any%20column%20of%20your%20chart%20(better%20on%20right%20one)%20-%20data%20series%20will%20be%20selected%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20391px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F132680iA2D13125525641D8%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3ENow%20two%20variants.%20Click%20again%20on%20this%20column%20(single%20click)%2C%20after%20that%20on%20ribbon%20select%20Format%20section%20and%20next%20click%20on%20Format%20selection%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20466px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F132684iFD27467C728B4886%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EAnother%20option%20just%20double%20click%20on%20this%20column.%3C%2FP%3E%0A%3CP%3EIn%20both%20cases%20right%20pane%20shall%20appear%20with%20options%20to%20format%20data%20point%2C%20here%20check%20Set%20as%20total%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20284px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F132685i597A2528227DAEC1%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20brief%2C%20you%20shall%20select%20last%20data%20point%20and%20format%20it%20as%20total.%20Finally%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20384px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F132686i91EBB26357A2843A%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-864012%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Web%20chart%20Waterfall%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-864012%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAnd%20finally%20I'm%20very%20sorry%2C%20I%20missed%20you%20asked%20for%20Excel%20Online.%20Will%20check%20if%20possible%20to%20total%20in%20it.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-866691%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Web%20chart%20Waterfall%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-866691%22%20slang%3D%22en-US%22%3EThanks%20Sergei%2C%3CBR%20%2F%3E%3CBR%20%2F%3EI'm%20ok%20with%20u%20for%20post%20but%20i%20can't%20find%20the%20same%20for%20excel%20web%20%3B%3CBR%20%2F%3EYou%20can%20test%20on%20the%20share%20excel%20link%20i%20posted%20%3A%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fpochet-my.sharepoint.com%2F%3Ax%3A%2Fg%2Fpersonal%2Fmickael_fougeres_groupe-pochet_fr%2FEba9E_GrxhxOsH5EIFxz4SsBVaBSmyXWk_V_w7pMiGFxvQ%3Fe%3DYM5aC9%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fpochet-my.sharepoint.com%2F%3Ax%3A%2Fg%2Fpersonal%2Fmickael_fougeres_groupe-pochet_fr%2FEba9E_GrxhxOsH5EIFxz4SsBVaBSmyXWk_V_w7pMiGFxvQ%3Fe%3DYM5aC9%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3B-))%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E
Highlighted
michaelFoug
New Contributor

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 !

 

clipboard_image_0.png

 

5 Replies

@michaelFoug 

Hi,

 

Double click on Total data point and Set it as total

image.png

 

@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

image.png

Now two variants. Click again on this column (single click), after that on ribbon select Format section and next click on Format selection

image.png

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

image.png

 

In brief, you shall select last data point and format it as total. Finally

image.png

@Sergei Baklan 

And finally I'm very sorry, I missed you asked for Excel Online. Will check if possible to total in it.

Thanks Sergei,

I'm ok with u for post but i can't find the same for excel web ;
You can test on the share excel link i posted :
https://pochet-my.sharepoint.com/:x:/g/personal/mickael_fougeres_groupe-pochet_fr/Eba9E_GrxhxOsH5EIF...

;-))
Related Conversations
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies