Tutorials›Excel›Charts & Graphs Basics
🟢 Free Demo
Excel TutorialTopic 26 of 31

Charts & Graphs Basics

Create professional column, bar, line, and pie charts in Excel to visualise data clearly for any audience.

✅ What You Will Learn

›How to create a chart from a data range in one click
›When to use column, bar, line, pie, and scatter charts
›How to add and format titles, axis labels, and data labels
›How to change chart type and move charts between sheets
›How to format charts for a professional, presentation-ready look

A chart converts numbers into a visual story. Humans process visual patterns far faster than tables of numbers — a line chart showing a sales decline across 12 months communicates the trend instantly, while a table of 12 numbers requires deliberate reading.

Excel has over 20 chart types. The four most used in business analysis are: Column (comparisons between categories), Line (trends over time), Bar (horizontal comparisons, good for long category names), and Pie or Doughnut (proportions — use only when you have fewer than 6 categories and they sum to a meaningful whole).

The fastest way to create a chart in Excel: select your data range and press Alt+F1 (inserts a default chart on the same sheet) or F11 (inserts a chart on a new sheet). Then customise from there.

Examples

Example 1Create a column chart from sales data
Steps:
1. Select your data range including headers (e.g. A1:B7 — Month, Sales)
2. Insert tab → Charts group → Column → Clustered Column
   (or press Alt+F1 for a quick default chart)
3. Chart appears on the sheet — drag to position it

Recommended chart types by purpose:
  Comparing categories     → Clustered Column or Bar
  Trend over time          → Line chart
  Part of a whole          → Pie or Doughnut (max 5–6 segments)
  Relationship between two → Scatter (XY)
  Cumulative total         → Area chart
💡

Excel Chart Recommended Charts feature (Insert tab) analyses your data and suggests the most appropriate chart type — useful when you are unsure.

Example 2Add and format chart elements for professionalism
Chart Title:
  Click the chart → Chart Design tab → Add Chart Element → Chart Title
  Double-click the title to edit it directly

Axis Titles:
  Add Chart Element → Axis Titles → Primary Horizontal / Vertical

Data Labels:
  Add Chart Element → Data Labels → Outside End (for column charts)

Legend:
  Move to top or right — right-click legend → Format Legend → Position

Remove gridlines for a cleaner look:
  Click gridlines → Delete key
💡

Every chart in a professional report needs: a descriptive title (not just "Sales"), labelled axes with units, and data labels on key data points. Test by showing to someone who has not seen the data.

📌 Key Points to Remember

  • ✓Alt+F1 inserts a default chart on the current sheet. F11 inserts it on a new chart sheet.
  • ✓Right-click any chart element (bar, line, axis, legend) → Format to open formatting options
  • ✓Chart Design tab → Change Chart Type lets you switch between types without starting over
  • ✓Avoid 3D charts — they distort proportions and make values harder to read
  • ✓Use consistent colours across all charts in a report — one colour per category, always the same category colour

🏢 Real-World Application

Business analysts present weekly performance charts to leadership teams. A well-formatted Excel chart — clean white background, no gridlines, clear title, data labels on key points — looks as professional as any created in dedicated design tools. Most management decks in Indian companies are built from Excel charts pasted into PowerPoint.

⚠️ Common Mistakes to Avoid

WRONGIncluding the total row in chart data — creates a bar that dwarfs all others
FIXSelect only the individual category rows, not the total row. If you need to show the total, add it as a separate data series with a different chart type (combo chart).
WRONGUsing pie charts with too many segments — impossible to read
FIXLimit pie charts to 5–6 segments maximum. Combine small segments into "Other". Better yet, use a horizontal bar chart sorted by value for any category comparison.
WRONGNot labelling axes — "what unit is this in?"
FIXEvery axis needs a label with units: "Revenue (₹ Lakhs)", "Month (Jan–Dec 2026)", "Units Sold". Without units, the chart requires the audience to guess.
✏️Test Yourself

Which chart type is most appropriate for showing monthly revenue over a 12-month period?

❓ Frequently Asked Questions

How do I add a trend line to a chart?

Right-click a data series in the chart → Add Trendline. Choose Linear for steady trends, Exponential for growth curves. Check "Display equation" and "Display R-squared" to show the statistical fit.

Can I link a chart title to a cell so it updates automatically?

Yes — click the chart title, then in the formula bar type = and click the cell you want it to read from. The title updates automatically when the cell changes. Useful for date-based report titles.

How do I create a chart with two different chart types (combo)?

Right-click any data series → Change Series Chart Type → Combo. Set one series to Column and another to Line. You can also add a secondary axis for series with very different value ranges.

✏️ Practice Exercise

Using a 12-month sales dataset with 3 product categories, create: (1) A line chart showing monthly trends for all 3 categories, (2) A clustered column chart comparing Q1, Q2, Q3, Q4 totals by category, (3) A pie chart showing the annual sales split by category. Format all three for presentation: professional title, axis labels, consistent colours, no gridlines.

← PreviousMath FunctionsNext →What-If Analysis
🎓 Level Up Faster

Learn Excel with Live Trainer Guidance

These tutorials give you the foundations. Our live Excel course at EVIKA Academy, Noida teaches you to build real dashboards on actual business data — with a trainer who uses Excel professionally every day.