Home

Excel statistical charting

%3CLINGO-SUB%20id%3D%22lingo-sub-886504%22%20slang%3D%22en-US%22%3EExcel%20statistical%20charting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-886504%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20there%20a%20way%20to%20set%20the%20numerical%20range%20to%20plot%20in%20an%20occurrence%20plot%3F%3C%2FP%3E%3CP%3EI%20want%20to%20plot%20the%20occurrence%20of%20positive%20values%20from%20a%20column%20of%20data%20which%20contains%20%22zeros%22%20for%20missing%20data.%26nbsp%3B%20I%20wish%20to%20exclude%20any%20values%20less%20than%200.01.%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20to%20do%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-886504%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-886936%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20statistical%20charting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-886936%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F418134%22%20target%3D%22_blank%22%3E%40grosed%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20may%20add%20helper%20column%2Frow%20with%20formula%20like%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-markup%22%3E%3CCODE%3E%3DIF(A1%26lt%3B%3D0.01%2CNA()%2CA1)%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3Eand%20plot%20chart%20on%20it%20adding%20for%20hidden%20and%20empty%20cells%20setting%20like%20this%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20304px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F134973iECEA4ACF29917032%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
grosed
Occasional Visitor

Is there a way to set the numerical range to plot in an occurrence plot?

I want to plot the occurrence of positive values from a column of data which contains "zeros" for missing data.  I wish to exclude any values less than 0.01.

Is there a way to do this?

1 Reply
Highlighted

@grosed 

You may add helper column/row with formula like

=IF(A1<=0.01,NA(),A1)

and plot chart on it adding for hidden and empty cells setting like this

image.png

 

Related Conversations
Extentions Synchronization
ChirmyRam in Discussions on
3 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies