Loading…
Loading…
One chart can compare several series: select the category column and every value column (with headers) and each column becomes a line or a set of bars. You can also chart a PivotTable: build the summary first, then chart its rows (leave out the Grand Total, or it dwarfs everything else). Give every chart a title that says what the reader should notice.
Common mistakes
Read the lesson, then try it yourself in a live spreadsheet.