excel logarithmic scaling boxplot

%3CLINGO-SUB%20id%3D%22lingo-sub-1392895%22%20slang%3D%22en-US%22%3Eexcel%20logarithmic%20scaling%20boxplot%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1392895%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20i%20transfered%20my%20boxplot%20diagram%20from%20SPSS%20to%20excel%20where%20i%20want%20to%20edit%20it.%20Now%20im%20trying%20to%20change%20the%20y-axis%20to%20a%20logarithmic%20scaling%20but%20there%20is%20no%20option%20for%20this.%20Can%20somebody%20help%20me%3F%20Thx!!%20Angelika%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1392895%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2580282%22%20slang%3D%22en-US%22%3ERe%3A%20excel%20logarithmic%20scaling%20boxplot%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2580282%22%20slang%3D%22en-US%22%3EDid%20anyone%20find%20an%20answer%20to%20the%20question%20above%3F%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2587170%22%20slang%3D%22en-US%22%3ERe%3A%20excel%20logarithmic%20scaling%20boxplot%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2587170%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%2F669202%22%20target%3D%22_blank%22%3E%40anmian%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20hope%20it%20will%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETo%20tell%20Excel%20that%20you%20want%20to%20use%20logarithmic%20scaling%20of%20the%20value%20access%2C%20follow%20these%20steps%3A%3C%2FP%3E%3COL%20class%3D%22level-one%22%3E%3CLI%3E%3CP%20class%3D%22first-para%22%3ERight-click%20the%20value%20(Y)%20axis%20and%20then%20choose%20the%20Format%20Axis%20command%20from%20the%20shortcut%20menu%20that%20appears.%3C%2FP%3E%3C%2FLI%3E%3CLI%3E%3CP%20class%3D%22first-para%22%3EWhen%20the%20Format%20Axis%20dialog%20box%20appears%2C%20select%20the%20Axis%20Options%20entry%20from%20the%20list%20box.%3C%2FP%3E%3C%2FLI%3E%3CLI%3E%3CP%20class%3D%22first-para%22%3ETo%20tell%20Excel%20to%20use%20logarithmic%20scaling%20of%20the%20value%20(Y)%20axis%2C%20simply%20select%20the%20Logarithmic%20Scale%20check%20box%20and%20then%20click%20OK.%3C%2FP%3E%3CP%20class%3D%22child-para%22%3EExcel%20re-scales%20the%20value%20axis%20of%20your%20chart%20to%20use%20logarithmic%20scaling.%20Note%20that%20initially%20Excel%20uses%20base%2010%20logarithmic%20scaling.%20But%20you%20can%20change%20the%20scaling%20by%20entering%20some%20other%20value%20into%20the%20Logarithmic%20Scale%20Base%20box.%3C%2FP%3E%3C%2FLI%3E%3C%2FOL%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2587384%22%20slang%3D%22en-US%22%3ERe%3A%20excel%20logarithmic%20scaling%20boxplot%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2587384%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1085077%22%20target%3D%22_blank%22%3E%40Qaiser_j%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2590099%22%20slang%3D%22en-US%22%3ERe%3A%20excel%20logarithmic%20scaling%20boxplot%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2590099%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1111128%22%20target%3D%22_blank%22%3E%40Sweet2020%3C%2FA%3E%26nbsp%3BYou%20welcome!%26nbsp%3B%3CIMG%20class%3D%22lia-deferred-image%20lia-image-emoji%22%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Fhtml%2F%408341BD79091AF36AA2A09063B554B5CD%2Fimages%2Femoticons%2Fsmile_40x40.gif%22%20alt%3D%22%3Asmile%3A%22%20title%3D%22%3Asmile%3A%22%20%2F%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi, i transfered my boxplot diagram from SPSS to excel where i want to edit it. Now im trying to change the y-axis to a logarithmic scaling but there is no option for this. Can somebody help me? Thx!! Angelika

4 Replies
Did anyone find an answer to the question above?

Hi @anmian 

 

I hope it will help.

 

To tell Excel that you want to use logarithmic scaling of the value access, follow these steps:

  1. Right-click the value (Y) axis and then choose the Format Axis command from the shortcut menu that appears.

  2. When the Format Axis dialog box appears, select the Axis Options entry from the list box.

  3. To tell Excel to use logarithmic scaling of the value (Y) axis, simply select the Logarithmic Scale check box and then click OK.

    Excel re-scales the value axis of your chart to use logarithmic scaling. Note that initially Excel uses base 10 logarithmic scaling. But you can change the scaling by entering some other value into the Logarithmic Scale Base box.

@Qaiser_j 

Thanks!

@Sweet2020 You welcome! :smile: