4 tutorials tagged “charts”.
Fix an Excel or Google Sheets chart that shows 45299 instead of 8 Jan 2024 on the axis. Why date serials appear, how to format the axis, and what to do when the source is text.
Fix an Excel or Google Sheets chart that is missing rows, drops new data, or hides a series. Check the data range, hidden rows, blanks, and whether a table has expanded.
Plot two series of very different scale on one Excel or Google Sheets chart by adding a secondary axis, and check the figures against the source totals.
Make a column, line, or pie chart in Excel from a clean summary range. Includes a tested monthly sales table, what to leave out of the data, and the Google Sheets menu names.