Excel has so many charts that the best one for the job is often easy to miss. You might instinctively reach for the familiar column chart, but that can cause more problems than it solves by obscuring ...

Quartiles are the values that divide a data set into quarters: Put the values in order Divide the list into four equal parts The Quartiles are at the divisions The interquartile range shows the range ...

Box plots present the same data in a different way and can be used to make comparisons between two similar datasets. Add an additional column, if not provided, to the grouped frequency table. Label ...

Bar charts are a way to represent categorical data visually, in a horizontal or vertical display. Bars can be single, stacked, or grouped. By looking through the whole chart, it is easy to see the ...