Choose a spreadsheet chart for my columns
Recommends the spreadsheet chart type for your pasted columns and the question you want to answer, without inventing numbers.
Task:
Recommend one chart type for the spreadsheet data below and say how to select the cells for it.
Context:
The question the chart must answer is [the question]. It goes into [report, slide or email] for [audience].
Rules:
- Judge by what each column holds (category, date, number) and by how many rows there are.
- Do not invent numbers. Mark any figure you computed, such as a count of rows, as "computed" and any figure you only read from the paste as "read".
- Say so when the data is too thin or too messy to support the chart, and name what is missing.
- Describe the setup by what to select and which axis gets what, not by menu names.
Result:
The chart type in one sentence, then up to five setup steps, then one line on the most likely way this chart misleads with my data.
Material:
[paste the column headers and 10 to 20 sample rows here]