Home

Trendline: how to hide the cero value

%3CLINGO-SUB%20id%3D%22lingo-sub-664243%22%20slang%3D%22en-US%22%3ETrendline%3A%20how%20to%20hide%20the%20cero%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-664243%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20there!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20creating%20a%20chart%20but%20the%20trendline%20also%20shows%20the%20cero%20value%20so%20the%20trendline%20%22goes%20down%22%3A%20do%20you%20know%20how%20to%20solve%20it%3F%20Please%20check%20the%20attachment.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThansk%20in%20advance!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-664243%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-664821%22%20slang%3D%22en-US%22%3ERe%3A%20Trendline%3A%20how%20to%20hide%20the%20cero%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-664821%22%20slang%3D%22en-US%22%3EHi%20Francesco%20I%20tried%20to%20determinate%20what%20is%20happening%20looking%20at%20the%20attachment%20but%20it's%20difficult%2C%20could%20you%20share%20the%20excel%20with%20the%20table%20so%20I%20can%20check%20what%20range%20of%20data%20belongs%20to%20each%20tendency%20line%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-665003%22%20slang%3D%22en-US%22%3ERe%3A%20Trendline%3A%20how%20to%20hide%20the%20cero%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-665003%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F342487%22%20target%3D%22_blank%22%3E%40CarlosCorral%3C%2FA%3E%26nbsp%3Bplease%20find%20herewith%20the%20data.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-665033%22%20slang%3D%22en-US%22%3ERe%3A%20Trendline%3A%20how%20to%20hide%20the%20cero%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-665033%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F353599%22%20target%3D%22_blank%22%3E%40FrancescoBarcelona%3C%2FA%3E%26nbsp%3BHi%20Francesco%2C%20I%20know%20what%20is%20happening%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20problem%20is%20that%20the%20serie%20that%20generates%20the%20tendency%20has%20filled%20out%20with%20zero%20until%20end%20of%20year%2C%20so%20the%20tendency%20is%20showing%20that%2C%20to%20solve%20this%20you%20have%20to%20empty%20the%20rest%20of%20the%20year%2C%20so%20the%20tendency%20only%20get%20calculated%20over%20the%20real%20data.%26nbsp%3B%20Try%20that%20and%20let%20me%20know%20if%20works%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-667694%22%20slang%3D%22en-US%22%3ERe%3A%20Trendline%3A%20how%20to%20hide%20the%20cero%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-667694%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F342487%22%20target%3D%22_blank%22%3E%40CarlosCorral%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDo%20you%20think%20there%20is%20not%20another%20solution%3F%20I%20mean%2C%20if%20I%20will%20put%20zeros%20I%20will%20lose%20the%20formula.%20It's%20not%20a%20big%20issue%20but...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20you%20help!%3C%2FP%3E%3C%2FLINGO-BODY%3E
FrancescoBarcelona
New Contributor

Hi there!

 

I'm creating a chart but the trendline also shows the cero value so the trendline "goes down": do you know how to solve it? Please check the attachment.

 

Thansk in advance!

6 Replies
Hi Francesco I tried to determinate what is happening looking at the attachment but it's difficult, could you share the excel with the table so I can check what range of data belongs to each tendency line?

Hi @CarlosCorral please find herewith the data. 

 

Thanks

@FrancescoBarcelona Hi Francesco, I know what is happening

 

The problem is that the serie that generates the tendency has filled out with zero until end of year, so the tendency is showing that, to solve this you have to empty the rest of the year, so the tendency only get calculated over the real data.  Try that and let me know if works

Highlighted

Hi @CarlosCorral,

 

Do you think there is not another solution? I mean, if I will put zeros I will lose the formula. It's not a big issue but...

 

Thanks for you help!

@FrancescoBarcelona  Hi Francesco, I'm not an expert so I cannot tell you that's the definitive solution, but, based on how the tendency line is calculated, I think it is.  Remember that zero's affect the calculation.

You can use a IF function to ask if there is a data for a specific cell, if true you put the formula if don't you put "blank" maybe that could help you.

Hi @CarlosCorral, many thanks!

 

Have a nice evening! 

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
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies