SOLVED

how to adjust values in vertical axis of line chart and include an entry on the horizontal axis

%3CLINGO-SUB%20id%3D%22lingo-sub-3095637%22%20slang%3D%22en-US%22%3Ehow%20to%20adjust%20values%20in%20vertical%20axis%20of%20line%20chart%20and%20include%20an%20entry%20on%20the%20horizontal%20axis%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3095637%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%20I'm%20having%20problems%20getting%20this%20data%20set%20into%20a%20line%20graph%3A%3C%2FP%3E%3CP%3EDate%20E.%20coli%20Count%3C%2FP%3E%3CTABLE%20width%3D%22273%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%22273%22%3ESample%20Results%20Over%20Time%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E3%2F26%2F2021%3C%2FTD%3E%3CTD%3E1540000.0%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E1450000.0%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E10%2F22%2F2021%3C%2FTD%3E%3CTD%3E10000.0%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E4978.0%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E11%2F29%2F2021%3C%2FTD%3E%3CTD%3E721.5%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E49.9%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E12%2F22%2F2021%3C%2FTD%3E%3CTD%3E721.5%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E325.5%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E1%2F24%2F2022%3C%2FTD%3E%3CTD%3E0.0%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E0.0%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ewhen%20i%20select%20the%20data%20set%20as%20directed%2C%20the%20line%20graph%20(which%20is%20what%20i%20want%20to%20use)%20looks%20like%20this%3A%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%20image-alt%3D%22CarolynW_0-1643664424696.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F344023i5F292FD7F06A35FB%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22CarolynW_0-1643664424696.png%22%20alt%3D%22CarolynW_0-1643664424696.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eas%20you%20can%20see%2C%20the%20vertical%20axis%20is%20automatically%20doing%20a%2020k%20increment%2C%20which%20basically%20leaves%20out%20all%20the%20results%20under%2020k%2C%20which%20i%20want%20to%20show%2C%20and%20plots%20them%20as%200%20values%20%3A(.%26nbsp%3B%20also%2C%20the%20graph%20automatically%20added%20all%20these%20months%20where%20no%20tests%20were%20conducted%20(%3F)%20and%20the%20date%20of%20the%20last%20tests%20is%20missing%20entirely.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ewhen%20i%20try%20to%20change%20the%20vertical%20axis%20increments%20to%20show%20what%20i%20need%2C%20it%20comes%20out%20like%20this%20with%20all%20the%20values%20mushed%20together%20at%20the%20bottom%3A%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%20image-alt%3D%22CarolynW_1-1643664913584.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F344024iE975DCF6BC199B84%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22CarolynW_1-1643664913584.png%22%20alt%3D%22CarolynW_1-1643664913584.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethis%20just%20seems%20like%20it%20should%20be%20so%20simple!!%26nbsp%3B%20I've%20used%20excel%20graphing%20for%20over%2020%20years%20but%20i%20can't%20figure%20this%20one%20out%20%3CLI-EMOJI%20id%3D%22lia_disappointed-face%22%20title%3D%22%3Adisappointed_face%3A%22%3E%3C%2FLI-EMOJI%3E%20Any%20help%20would%20be%20very%20greatly%20appreciated%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3095637%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3095812%22%20slang%3D%22en-US%22%3ERe%3A%20how%20to%20adjust%20values%20in%20vertical%20axis%20of%20line%20chart%20and%20include%20an%20entry%20on%20the%20horizontal%20axis%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3095812%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1292811%22%20target%3D%22_blank%22%3E%40CarolynW%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EDouble-click%20the%20Y-axis.%3C%2FP%3E%0A%3CP%3ETick%20the%20check%20box%20'Logarithmic%20scale'.%3C%2FP%3E%0A%3CP%3EYou'll%20get%20a%20warning%20that%200%20values%20cannot%20be%20displayed.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22S1115.png%22%20style%3D%22width%3A%20261px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F344035i732EF9A989D6DA34%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22S1115.png%22%20alt%3D%22S1115.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi all I'm having problems getting this data set into a line graph:

Date E. coli Count

Sample Results Over Time
 
3/26/20211540000.0  
 1450000.0  
10/22/202110000.0  
 4978.0  
11/29/2021721.5  
 49.9  
12/22/2021721.5  
 325.5  
1/24/20220.0  
 0.0  
    

 

when i select the data set as directed, the line graph (which is what i want to use) looks like this:

 

CarolynW_0-1643664424696.png

 

as you can see, the vertical axis is automatically doing a 20k increment, which basically leaves out all the results under 20k, which i want to show, and plots them as 0 values :(.  also, the graph automatically added all these months where no tests were conducted (?) and the date of the last tests is missing entirely.

 

when i try to change the vertical axis increments to show what i need, it comes out like this with all the values mushed together at the bottom:

 

CarolynW_1-1643664913584.png

 

this just seems like it should be so simple!!  I've used excel graphing for over 20 years but i can't figure this one out Any help would be very greatly appreciated

 

2 Replies

@CarolynW 

Double-click the Y-axis.

Tick the check box 'Logarithmic scale'.

You'll get a warning that 0 values cannot be displayed.

S1115.png

best response confirmed by CarolynW (New Contributor)
Solution
Thank you so much!! Have a great day