Forum Discussion
anmian
May 15, 2020Copper Contributor
excel logarithmic scaling boxplot
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
5 Replies
Sort By
- Qaiser_jBrass Contributor
Hi anmian
I hope it will help.
To tell Excel that you want to use logarithmic scaling of the value access, follow these steps:
Right-click the value (Y) axis and then choose the Format Axis command from the shortcut menu that appears.
When the Format Axis dialog box appears, select the Axis Options entry from the list box.
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.
- waterTech80Copper Contributor
Qaiser_j unfortunately the named option for editing the y-achsis is not available for box plots...
Do you know of another way to transform the achsis?
Calculating the log of my data and showing with decadic achsis leads to a wrong presentation of the dataset...
Best regards and thanks in advance!
Arthur
- Sweet2020Copper Contributor
Thanks!
- Sweet2020Copper ContributorDid anyone find an answer to the question above?