Home

Chart won't plot a zero

%3CLINGO-SUB%20id%3D%22lingo-sub-756411%22%20slang%3D%22en-US%22%3EChart%20won't%20plot%20a%20zero%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-756411%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EI'm%20making%20a%20chart%20and%20for%20some%20reason%20it%20won't%26nbsp%3Bplot%20a%20value%20at%20zero%2C%20instead%20it%20plots%20it%20at%201%20and%20the%20data%20that%20was%20meant%20to%20be%20plotted%20at%201%20at%202%20etc.%20Is%20there%20anyone%20who%20has%20an%20idea%20why%20this%20might%20be%20happening%3F%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-756411%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-756424%22%20slang%3D%22en-US%22%3ERe%3A%20Chart%20won't%20plot%20a%20zero%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-756424%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F376924%22%20target%3D%22_blank%22%3E%40Jenny_Ward_%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%26nbsp%3B%3C%2FP%3E%3CP%3EAre%2FIs%20the%20zero(s)%20visible%20in%20the%20data-set%20(cell%2Fs)%20from%20which%20the%20graph%20is%20based%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-758494%22%20slang%3D%22en-US%22%3ERe%3A%20Chart%20won't%20plot%20a%20zero%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-758494%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F376924%22%20target%3D%22_blank%22%3E%40Jenny_Ward_%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%2C%20highlight%20the%20graph%20and%20press%20ctrl%20%2B1%2C%20Format%20axis%2C%26nbsp%3B%3CSPAN%3Eexpand%20the%20Axis%20Options%20section%20and%20set%20the%20Minimum%20value%20to%200.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Jenny_Ward_
Occasional Visitor

Hi,

I'm making a chart and for some reason it won't plot a value at zero, instead it plots it at 1 and the data that was meant to be plotted at 1 at 2 etc. Is there anyone who has an idea why this might be happening?

Thanks

2 Replies

@Jenny_Ward_ 

 

Hi 

Are/Is the zero(s) visible in the data-set (cell/s) from which the graph is based? 

@Jenny_Ward_ 

 

Hi, highlight the graph and press ctrl +1, Format axis, expand the Axis Options section and set the Minimum value to 0.

Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
202 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies