Create charts and explain what they show
Ask AI to create a suitable chart from a dataset and explain the main patterns, changes or outliers in plain language.
Where the action happens
Excel / Analyst
Product or feature needed
Data visualisation and explanation
AI required
Yes
Extra credits
Feature-specific
Technical skill
Low to medium
Risk level
Medium
Licence dependency
Depends on Excel/Analyst capabilities.
Credit dependency
Feature-specific.
UK availability
available
What it can do
- Suggest useful visualisations.
- Create charts from structured data.
- Explain visible patterns in plain language.
Limitations
- A chart can be technically correct but misleading if the data or scale is inappropriate.
Prerequisites
- Review chart choices and conclusions.
Notes
Generic capability.
Watch-outs for Work with data
- Check important calculations and conclusions before relying on them.
- This section focuses on capability; organisational rules determine which datasets are appropriate to use.
- For regulated or consequential decisions, keep human accountability.
Last checked: 2026-10-09
Disclaimer: Always follow your organisation's internal guidance and policies regarding AI usage. The suggestions in this guide have been created to the best of accuracy, but Microsoft licensing, pricing and feature availability change frequently — treat them as a planning baseline, not a procurement quote.
Community feedback
Has your organisation tried this? Confirm whether it's possible, whether it's useful, and share any tips.
0
Confirmed possible
0
Reported not possible
0
Found it useful
0
Not useful
Loading feedback…