Creating Your First Chart
Turn a table of numbers into a chart that's actually easy to read at a glance.
Compatibility: All Excel versions
What You'll Learn
- How to insert a chart from a selected range
- The difference between a column chart and a line chart
- Why a chart updates automatically when its source data changes
- When a pie chart is (and isn't) the right choice
Select your data — including the header row — and go to Insert > Charts. For most simple comparisons, a Column Chart (for comparing categories) or a Line Chart (for showing change over time) is the right starting point.
What Makes a Chart Useful
A chart should make a comparison obvious faster than the raw numbers would. Give it a clear title, label your axes if it isn't obvious what they represent, and remove legend entries or gridlines that don't add anything.
Charts Update With Your Data
A chart is linked to the cells it was built from — change a number in your table, and the chart updates automatically. This is different from pasting a picture of your data, which would need to be manually redone every time something changes.
Choosing the Right Chart Type
A common mistake is reaching for a Pie Chart by default — pie charts only work well for a small number of categories that add up to a meaningful whole. For most everyday comparisons, a simple column or bar chart is easier to read accurately.
Common Mistakes
- Defaulting to a pie chart with too many categories, making it hard to read
- Forgetting to include header labels in the selection before inserting the chart
Practice Exercise
Build a small table of monthly sales for 4 months. Create a column chart from it, give it a title, then change one of the sales numbers and watch the chart update on its own.
Key Takeaways
- Select your data including headers, then Insert > Charts
- Column charts compare categories; line charts show change over time
- Charts stay linked to their source data and update automatically