Summary

This article shows you how to create, format, and customize charts and graphs in Microsoft Excel to visualize your data. Charts make trends, comparisons, and patterns easier to understand at a glance — whether you are building a report, a presentation, or a dashboard.

In this guide

• 1. Prepare Your Data
• 2. Insert a Chart
• 3. Customize the Chart Design
• 4. Add and Edit Chart Elements
• 5. Format Individual Chart Elements
• 6. Move a Chart to Its Own Sheet
• 7. Copy a Chart to PowerPoint or Word
• 8. Choose the Right Chart Type
• 9. Build a PivotChart When the Data Needs Summarizing First

Before You Start

• Microsoft Excel (desktop or web version).
• A spreadsheet with organized data — ideally with column headers in the first row and values in the rows below.

Instructions

1. Prepare Your Data

Charts work best when your data is clean and structured.

1. Organize your data in a table format — column headers in Row 1, data values in the rows below.

   • Example:

     Month	Sales	Expenses
     January	12000	8500
     February	15000	9200
     March	13500	8800

2. Remove any blank rows or columns within your data range — gaps can cause Excel to misinterpret the chart range.

3. Ensure numbers are formatted as numbers (not stored as text). If a cell shows a green triangle in the corner, click it and select Convert to Number.

2. Insert a Chart

1. Select your data — Click and drag to highlight the cells you want to chart, including the column headers.
2. Click the Insert tab on the ribbon.
3. In the Charts group, choose a chart type:
   • Column / Bar — Best for comparing values across categories.
   • Line — Best for showing trends over time.
   • Pie / Doughnut — Best for showing parts of a whole (use only with one data series).
   • Scatter (XY) — Best for showing relationships between two numeric variables.
   • Area — Similar to line charts but emphasizes volume.
4. Click the specific chart subtype you want (e.g., Clustered Column, Stacked Bar, Line with Markers).
5. Excel inserts the chart into your worksheet. Click and drag it to reposition it.

Tip: Not sure which chart to use? Select your data, click Insert > Recommended Charts, and Excel will suggest the best chart types based on your data structure.

3. Customize the Chart Design

After inserting a chart, you can change its overall look using the Chart Design tab (appears when the chart is selected).

1. Change chart type — Click Change Chart Type to switch between column, line, pie, etc., without re-creating the chart.
2. Switch Row/Column — Click Switch Row/Column if the axes are swapped (e.g., months on the wrong axis).
3. Quick Layout — Click Quick Layout to apply a preset arrangement of titles, legends, and data labels.
4. Chart Styles — Browse the style gallery on the ribbon to apply a visual theme (colors, shading, outlines).
5. Change Colors — Click Change Colors to pick a different color palette.

4. Add and Edit Chart Elements

Chart elements include titles, labels, legends, and gridlines. You can add or remove them individually.

1. Click the chart to select it.
2. Click the + (Chart Elements) button that appears in the top right corner of the chart.
3. Check or uncheck elements:
   • Chart Title — Add a descriptive title. Click the title text to edit it.
   • Axis Titles — Label the horizontal (X) and vertical (Y) axes.
   • Data Labels — Show exact values on each data point.
   • Legend — Show or hide the legend, and choose its position (top, bottom, left, right).
   • Gridlines — Toggle major and minor gridlines for readability.
   • Trendline — Add a linear, exponential, or moving average trendline to spot trends.
4. Hover over any element and click the arrow to see additional options (e.g., legend position, label format).

5. Format Individual Chart Elements

You can fine-tune the appearance of any part of the chart.

1. Double-click any element in the chart (a bar, a line, the title, an axis, etc.) to open the Format pane on the right.
2. In the Format pane, you can adjust:
   • Fill & Line — Change bar colors, line styles, and border widths.
   • Effects — Add shadows, glow, or 3-D effects (use sparingly).
   • Size & Properties — Adjust dimensions and text wrapping.
3. To change a single data point's color (e.g., highlight one bar), click once on the data series (selects all bars), then click again on the specific bar (selects only that specific one), and change its fill color.

6. Move a Chart to Its Own Sheet

If you want the chart on a full-page sheet instead of embedded in the data worksheet:

1. Click the chart to select it.
2. Go to the Chart Design tab.
3. Click Move Chart.
4. Select New sheet and give it a name (e.g., "Sales Chart").
5. Click OK. The chart now occupies its own tab in the workbook.

7. Copy a Chart to PowerPoint or Word

Charts can be pasted into other Office documents while keeping a link to the source data.

1. Click the chart in Excel and press Ctrl + C.
2. Open your PowerPoint slide or Word document.
3. Press Ctrl + V to paste.
4. A Paste Options icon appears — choose one of:
   • Keep Source Formatting & Link Data — The chart updates when the Excel data changes.
   • Keep Source Formatting & Embed Workbook — A snapshot that does not update.
   • Paste as Picture — A static image of the chart.

Tip: For presentations, Keep Source Formatting & Link Data is ideal if you plan to update the numbers before presenting.

8. Choose the Right Chart Type

Start from the question you are trying to answer rather than from the chart gallery, because each chart shape answers a different kind of question well.

Almost every chart in a work report is doing one of four jobs: comparing categories, showing change over time, showing what a total is made of, or showing whether two numbers move together. Name the job first and the chart type stops being a matter of taste.

The question you are answering	The chart that answers it	Why that shape works
Which of these is biggest? (comparing categories)	Clustered Column, or Bar when the category names are long	Every bar starts from the same baseline, so the eye compares lengths accurately.
What happened over time? (change over time)	Line, or Area when the total volume matters as much as the shape	A line reads left to right the way a timeline does, and the slope carries the message.
What is this total made of? (composition)	Stacked Column or Stacked Bar; Pie or Doughnut for a handful of slices	Segments of one bar add up to a visible whole, and you can still compare across bars.
Do these two numbers move together? (relationship)	Scatter (XY)	Each record becomes one point plotted against two numeric axes, so a pattern in the cloud is the answer.
Who is ahead? (ranking)	Horizontal Bar, sorted largest to smallest	Sorting does the work — the reader sees the order before reading a single label.
How far along are we? (progress to a target)	Bar with a target line added through Insert > Combo	The gap between the bar and the line is the number the reader wants.
Two measures on very different scales	Combo Chart (Insert > Combo), with the smaller series on a secondary axis	Keeps both visible when one is in millions and the other in percentages.

Three charts people reach for and regret

• A pie chart with more than about five slices. The human eye is poor at comparing angles, and past five wedges the small ones become an unreadable fringe. If you find yourself adding data labels so the pie can be read, the chart is doing no work — use a sorted horizontal Bar chart instead, or combine the small categories into a single "Other" slice.
• A dual-axis chart used to imply a link. Two series on two different scales can be made to cross, diverge, or track each other by nothing more than where you set each axis minimum. Use one when both measures genuinely need to be read at once, label both axes, and match each axis color to its series. Do not use one as evidence that two things are related — that is what a Scatter (XY) chart is for.
• 3-D anything. The 3-D column, bar, and pie variants tilt the plot area, which means bars at the back are drawn smaller than bars at the front holding the same value. The depth adds no information and costs accuracy. Keep the flat version.

Tip: Select your data and click Insert > Recommended Charts to see Excel's own suggestions with a live preview of each. It reads the shape of your data, which is a reasonable second opinion once you know what question you are asking.

9. Build a PivotChart When the Data Needs Summarizing First

A PivotChart is a chart drawn from a PivotTable rather than from a range of cells, so Excel does the grouping and totaling before anything is plotted.

A normal chart plots the cells you highlighted, exactly as they are. If your sheet holds 4,000 individual sales rows, there is nothing there to chart — you would first build a summary table of sales by month or by region, then chart that table. A PivotChart removes the middle step: it summarizes and plots in one object, and it stays interactive afterwards. Microsoft describes a PivotChart as a graphical view of the data in its associated PivotTable, and changes to the layout or data in either one appear immediately in the other.

Create a PivotChart from a list of records

1. Click any cell inside your data.
2. Click the Insert tab, then PivotChart in the Charts group.
3. Choose where the PivotChart should go and click OK. Excel creates an empty chart with an empty PivotTable beside it, and opens a field list on the right.
4. Drag a text field such as Region into Axis (Categories), and a numeric field such as Sales into Values. The chart draws itself as you drag, and the PivotTable fills in alongside it.
5. Drag a second text field into Legend (Series) to split each bar — sales by region, broken out by product line.

Create one from a PivotTable you already have

1. Click any cell inside the existing PivotTable.
2. Click the Insert tab, then PivotChart.
3. Click OK. The chart appears already wired to that PivotTable, showing whatever the table currently shows.

How the two stay in step

• Filtering either one filters both. Change a slicer or a filter on the PivotTable and the chart follows; use the filter buttons on the chart and the table follows. There is one filter, displayed in two places.
• New rows in the source data reach both through a single refresh. Click any cell in the PivotTable, open the PivotTable Analyze tab, and click Refresh in the Data group — or press Alt + F5.
• Most formatting survives a refresh: chart elements you added, the layout, and the style. Trendlines, data labels, and error bars do not, so re-adding those is part of the routine if you refresh often.
• A PivotChart cannot be based on another PivotChart. Each one needs its own PivotTable behind it.

When a PivotChart is the answer, and when it is not

Reach for a PivotChart when	Reach for a normal chart when
The source is a long list of individual records rather than a summary.	The data is already a small, finished summary table.
You want to change what is being compared without rebuilding the chart.	The chart goes into a report or slide and must not change shape when someone clicks it.
The same data has to be shown by month this week and by region next week.	You need a Scatter (XY), Stock, or Bubble chart — those three cannot be used as PivotCharts.
New rows arrive regularly and you want one Refresh to update everything.	You need full control of every visual detail with no risk of a refresh undoing it.

If a PivotChart needs a chart type it cannot use, copy the PivotTable's results into blank cells, paste them with Paste Special > Values, and chart that range as a normal chart. The copy stops updating with the source — which is the point, and also the cost.

PivotTables have their own guide, including field layout, grouping, and refreshing: How to Create a PivotTable in Excel.

Troubleshooting

TIP

If your chart looks wrong after inserting it, the most common fix is to click Chart Design > Switch Row/Column — this swaps the axes and usually resolves layout issues immediately.

Symptom / Error	Potential Cause	Solution
Chart shows wrong data or is blank	Wrong cells selected or blank rows in data	Re-select the correct data range: right-click the chart > Select Data > update the range.
Axes are swapped (months on Y-axis)	Row/column orientation is incorrect	Click Chart Design > Switch Row/Column.
Pie chart has too many slices	Too many categories in the data	Combine smaller categories into an "Other" group, or use a bar chart instead.
Numbers on axis are cut off	Axis scale is too large or too small	Double-click the axis > adjust Minimum, Maximum, and Major unit values in the Format pane.
Chart does not update when data changes	Chart range does not include new rows	Right-click the chart > Select Data > expand the data range to include new rows. Using an Excel Table (Ctrl + T) avoids this by auto-expanding.
Data labels overlap and are unreadable	Too many data points with labels	Remove data labels and use axis values instead, or display labels only on key points.
Scatter, Stock, or Bubble is unavailable in Change Chart Type	The chart is a PivotChart	A PivotChart can be any chart type except xy (scatter), stock, and bubble. Copy the PivotTable's results into blank cells, use Paste Special > Values, and chart that range as a normal chart.
Trendline or data labels vanish after a refresh	Not preserved on PivotChart refresh	Layout, style, and added chart elements survive a PivotChart refresh; trendlines, data labels, and error bars do not. Re-add them after refreshing, or chart a static summary range instead.
One series is a flat line along the bottom	Two measures on very different scales	Right-click the flattened series, choose Format Data Series, and set Plot Series On to Secondary Axis. Label both axes afterwards — without labels the reader cannot tell which line belongs to which scale.
A 3-D chart makes the front bars look larger	Perspective, not a data problem	The 3-D plot area draws distant bars smaller than near ones holding the same value. Click Chart Design > Change Chart Type and pick the flat equivalent.

Related Articles

• How to Create a PivotTable in Excel
• How to Use Conditional Formatting in Excel
• How to Use the Analyze Data Feature in Excel
• Understanding Excel Features — A Quick-Reference Guide to What Excel Can Do
• How to Use Presenter View in PowerPoint
• How to Create an Effective PowerPoint Presentation

Did this solve your problem?