No Ticket Needed

Appearance

4 min fix 7 min read Recently reviewedBeginner

By , IT support technician

Quick Answer

Select your data range, click the Insert tab, and choose a chart type (like a Column or Pie chart) to instantly visualize your data.

How to Create and Customize Charts in Excel ​

Applies to: Microsoft Excel (Desktop, Web), Microsoft 365
Article Type: How-To
Last Updated: 2026-05-18

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.

Prerequisites ​

  • 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:

      MonthSalesExpenses
      January120008500
      February150009200
      March135008800

  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 ​

Data ScenarioRecommended Chart
Compare values across categoriesClustered Column or Bar
Show trends over timeLine or Area
Show parts of a whole (one series)Pie or Doughnut
Compare two numeric variablesScatter (XY)
Show progress toward a targetGauge (via Doughnut workaround) or Bar with target line
Display rankings or leaderboardsHorizontal Bar (sorted)
Combine different chart types (e.g., bars + line)Combo Chart (Insert > Combo)

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 / ErrorPotential CauseSolution
Chart shows wrong data or is blankWrong cells selected or blank rows in dataRe-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 incorrectClick Chart Design > Switch Row/Column.
Pie chart has too many slicesToo many categories in the dataCombine smaller categories into an "Other" group, or use a bar chart instead.
Numbers on axis are cut offAxis scale is too large or too smallDouble-click the axis > adjust Minimum, Maximum, and Major unit values in the Format pane.
Chart does not update when data changesChart range does not include new rowsRight-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 unreadableToo many data points with labelsRemove data labels and use axis values instead, or display labels only on key points.