Chart / Visual Recommendation
Recommend appropriate visuals for a question and data shape. The analysis stays yours.
The prompt
I want to show [message/relationship] from data shaped like [describe columns/grain]. Recommend: - 2-3 suitable chart types and when each works best - What to put on each axis / encoding - Pitfalls (truncated axes, dual axes, too many series) This guides design — the underlying analysis and the numbers are mine to validate.
How to use it
- 1Select Copy the prompt above.
- 2Paste it into Microsoft 365 Copilot.
- 3Replace anything in brackets with your own detail, then send it.
Copilot gathers and drafts. You verify and decide. Check every figure, name and date against the system it came from before you act on it.
Written for
BI Analyst, Data Analyst, Business Analyst
More for Data & Analytics
- Data & Analytics Critical Guardrails - Read First
- Dataset Profiling Prep
- Anomaly / Outlier Exploration
- Ad-hoc Analysis Plan
From the source collection in awesome-microsoft-copilot-prompts, licensed CC BY-SA 4.0.