How to use the Spreadsheet Chart Recommender.
Choose a chart based on the comparison the reader must make. Avoid using visual complexity to compensate for unclear data definitions.
Make the workflow fit your task.
Describe the decision the chart should support, identify variable types and confirm units and time order. Compare a small number of suitable chart forms and explain what each emphasizes. Include labeling, missing-data and scale choices in the recommendation.
- What you provide
- Data schema and communication goal.
- What you get
- Appropriate chart choices and misleading alternatives to avoid.
See the input and the result.
Illustrative input and output · a teaching example, not a live WebAct run
Example input
Monthly revenue across a single year.
Completed example
A line chart can show change over time; use clear month order, currency units and a readable axis scale.
Load this input into the prompt, then copy it to WebAct to try the task. Your result may differ from the illustration.
Decisions and troubleshooting.
When is a bar chart preferable to a line chart?
Bars suit comparisons among distinct categories; lines emphasize ordered progression such as time. The intended comparison determines the choice.
Why does the suggested chart exaggerate small differences?
Inspect the axis limits, aspect ratio and omitted baseline context. Choose a scale that supports an honest reading of the measure.
Try it with your own source.
Replace the example with your material in the task prompt. Keep the requirements you need, then copy the task into WebAct.
Customize and copy the task ↑