Microsoft Excel - Boxplot - Axis Label Issue

%3CLINGO-SUB%20id%3D%22lingo-sub-1327055%22%20slang%3D%22en-US%22%3EMicrosoft%20Excel%20-%20Boxplot%20-%20Axis%20Label%20Issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1327055%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20visualise%20a%20questionnaire%20data.%20Each%20question%20can%20be%201%2C2%2C3%2C4%2C5.%20I%20currently%20need%20to%20use%20boxplot.%20There%20are%20major%20and%20minor%20unit%20settings%20in%20other%20types%20of%20plots.%20It%20appears%20to%20me%20that%20in%20boxplot%20axis%20settings%2C%20there%20is%20no%20option%20and%20excel%20sets%20this%20automatically.%20In%20my%20case%2C%20i%20can%20change%20max%20and%20min%20which%20i%20set%20them%20to%201%20and%205%20instead%20of%200%20and%206.%20But%2C%20excel%20adds%20numbers%20such%20as%201.5%2C%202.5%2C%203.5%2C%204.5.%20I%20tried%20to%20remove%20the%20decimal%20point%20and%20axis%20labels%20turned%20into%201%2C%201%2C%202%2C%202%2C%203%2C%203%2C%204%2C%204%2C%205%2C%205%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1327055%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

Hi

I am trying to visualise a questionnaire data. Each question can be 1,2,3,4,5. I currently need to use boxplot. There are major and minor unit settings in other types of plots. It appears to me that in boxplot axis settings, there is no option and excel sets this automatically. In my case, i can change max and min which i set them to 1 and 5 instead of 0 and 6. But, excel adds numbers such as 1.5, 2.5, 3.5, 4.5. I tried to remove the decimal point and axis labels turned into 1, 1, 2, 2, 3, 3, 4, 4, 5, 5

0 Replies