Excel Charts and Graphs

Charts and graphs turn rows and columns of numbers into visual representations that are much easier to understand and present. Instead of reading through hundreds of numbers, a chart can instantly show trends, comparisons, and patterns. Excel offers a wide variety of chart types, and creating one is straightforward.

Why Use Charts?

• A line chart can instantly show whether sales are rising or falling over time.
• A bar chart can compare products side by side.
• A pie chart can show what percentage each category contributes to the total.

Types of Charts in Excel

1. Column Chart / Bar Chart

Used to compare values across categories. Column charts are vertical, bar charts are horizontal.

Best for: Comparing monthly sales, comparing scores of different students.

2. Line Chart

Used to show trends over time. Data points are connected by a line.

Best for: Stock prices over months, temperature changes over a year.

3. Pie Chart

Used to show parts of a whole. The full circle represents 100% and each slice is a percentage.

Best for: Budget breakdown, market share by company.

4. Area Chart

Similar to a line chart, but the area below the line is filled in. Shows volume over time.

5. Scatter Chart (XY Chart)

Used to show relationships between two sets of data. Each point represents one data entry.

Best for: Correlation between advertising spend and revenue.

6. Combo Chart

Combines two different chart types — for example, a column chart for sales and a line chart for target — in one chart with two axes.

Creating a Basic Chart

Step-by-Step

1. Enter data in the spreadsheet (including headers).
2. Select the data range including the headers.
3. Go to Insert → Charts and choose a chart type.
4. The chart will appear on the same worksheet. It can be moved and resized.

Example Data

  | A       | B      |
1 | Month   | Sales  |
2 | January | 4000   |
3 | February| 5500   |
4 | March   | 4800   |
5 | April   | 6200   |
6 | May     | 7100   |

Steps

1. Select A1:B6.
2. Go to Insert → Column Chart → Clustered Column.
3. A column chart appears showing monthly sales comparison.

Recommended Charts

Excel can suggest the best chart type based on the selected data. Go to Insert → Recommended Charts and Excel will preview suitable chart types for the data.

Moving and Resizing a Chart

Moving a Chart

Click inside the chart (not on a data element) to select it. Then drag it to a new location on the sheet.

Moving to a New Sheet

1. Right-click the chart.
2. Select Move Chart.
3. Choose New Sheet and give it a name, or choose an existing sheet.

Resizing a Chart

Click the chart to select it. Small handles appear on the edges and corners. Click and drag any handle to resize.

Chart Elements

When a chart is selected, a small green + button appears to its right. Clicking it opens the Chart Elements panel to add or remove:

• Chart Title: A heading for the chart.
• Axis Titles: Labels for the horizontal (X) and vertical (Y) axes.
• Data Labels: Display the actual value on or near each data point or bar.
• Legend: A key showing what each color or series represents.
• Gridlines: Horizontal or vertical lines in the chart background.
• Data Table: Adds a table of the chart's source data below the chart.

Editing a Chart

Changing the Chart Type

1. Right-click on the chart.
2. Select Change Chart Type.
3. Choose a new chart type and click OK.

Editing the Chart Title

Double-click the chart title to edit the text directly on the chart.

Changing Chart Colors and Style

When the chart is selected, two additional tabs appear on the Ribbon: Chart Design and Format. Use these to change colors, apply styles, and adjust the layout.

Switching Rows and Columns

Go to Chart Design → Switch Row/Column to swap the data axes. This changes what is shown on the X-axis and what is used as data series.

Formatting Chart Elements

Individual parts of a chart can be formatted by double-clicking them. A formatting pane will appear on the right side.

Formatting a Data Series

Double-click a bar, line, or slice to format it. Options include fill color, border, transparency, and special effects.

Formatting Axes

Double-click an axis to set the minimum and maximum values, tick mark intervals, number format, and axis label appearance.

Sparklines

Sparklines are tiny charts that fit inside a single cell. They give a quick visual summary of trends without creating a full-sized chart.

Creating a Sparkline

1. Click the cell where the sparkline should appear.
2. Go to Insert → Sparklines → Choose Line, Column, or Win/Loss.
3. Select the data range for the sparkline.
4. Click OK.

Summary

• Charts turn data into visual representations that are easier to understand and present.
• Common chart types: Column (compare categories), Line (trends over time), Pie (parts of whole), Scatter (relationships).
• Charts are created by selecting data and going to Insert → Charts.
• Chart elements such as titles, axis labels, data labels, and legends can be added via the + button.
• Charts can be moved, resized, reformatted, and their type can be changed at any time.
• Sparklines are mini charts that fit inside individual cells for a quick trend overview.