Excel charts and graphs turn worksheet data into visual summaries that make comparisons, patterns, and changes easier to understand. In Microsoft Excel for Microsoft 365 on Windows, select a suitable data range, choose Insert > Recommended Charts or a chart type on the Insert tab, and then use the chart tabs to refine its labels, layout, and appearance.
What Excel Charts Are For
A chart represents worksheet values visually, usually with axes, data markers, labels, or a combination of these elements. The words “chart” and “graph” are often used interchangeably in everyday conversation. In Excel, chart is the usual product term, and the available chart types include column, line, pie, scatter, and many others.
Charts help readers see information that can be hard to spot in a grid of numbers. A column chart can make differences between product totals apparent; a line chart can reveal a rise or fall over time; and a scatter chart can show whether two measured variables appear related. A chart does not prove why a pattern exists, however. It presents the data in a visual form, so the choice of chart and the quality of the underlying data both matter.
Excel charts are linked to worksheet data. When source values change, a chart generally updates to reflect those changes. This makes a chart useful in a report that is refreshed regularly, but it also means that errors, missing values, or unexpected additions in the source range can affect the display.
Prepare the Data Before Charting
A clear chart starts with a tidy data range. Arrange the information in rows or columns, with a single header row or column that identifies each series. For example, a monthly sales table might have months in column A, product names across row 1, and sales values in the cells where each month and product meet.
Before inserting a chart, check that:
- Each column or row contains one kind of information, such as dates, product names, or sales amounts.
- Headers are descriptive and do not repeat unnecessarily.
- Numbers are stored as numbers, and dates are stored as dates, rather than as text that only looks numeric.
- There are no subtotal or grand-total rows mixed into the data unless you deliberately want them charted.
- Blank cells, errors, and unusually large or small values are understood rather than silently ignored.
For a simple table, select the headers and the associated data before inserting a chart. Excel often infers which values are series and which labels belong on the category axis. If the result is backwards—for example, Excel treats each month as a separate series instead of treating products as series—select the chart and choose Chart Design > Switch Row/Column. The precise contextual ribbon tabs appear when a chart is selected.
When a data set will grow, formatting it as an Excel table can make it easier to manage. Select a cell in the range and choose Insert > Table, confirm the range and whether it has headers, then create the chart from the table. Charts based on tables can include newly added table rows, although the exact behavior depends on how the chart’s source range was created and edited. Check the chart after changing the table structure.
Create a Chart in Excel
For most worksheets in Excel for Microsoft 365 on Windows, the basic process is:
- Select the cells that contain the labels and values to chart. Include the headers.
- Open the Insert tab and review Recommended Charts, or choose a chart type from the Charts group.
- Choose the chart that communicates the comparison or pattern clearly, and select OK if Excel presents a recommendation dialog.
- Click the chart to open its contextual Chart Design and Format tabs, then add or adjust the chart title, axis titles, legend, and data labels as needed.
- Resize or move the chart so it does not obscure important worksheet content.
Recommended Charts offers suggestions based on the selected range; it does not determine the best chart for the question being asked. Preview the options and check that the labels and series make sense. If you select a cell in a contiguous data range without selecting the whole range, Excel may identify the surrounding data automatically, but it is safer to verify the selected range and the resulting chart.
For a quick chart, select data and press Alt+F1 on Windows to create an embedded chart on the current worksheet. F11 creates a chart sheet, which places the chart on its own sheet. On Mac, keyboard shortcuts differ and can depend on macOS settings; use the Insert tab if a shortcut does not work. Excel for the web has chart creation and editing features too, but some advanced options and ribbon controls differ from the desktop application.
Choose the Right Chart Type
Choose a chart according to the relationship you want a reader to see, not just the appearance you prefer. Common choices include:
- Column or bar: Compare values across categories. Column charts use vertical bars; bar charts use horizontal bars and can be easier to read when category names are long.
- Line: Show change across an ordered sequence, especially time. A line chart is useful for monthly totals, but connecting unrelated categories can imply a continuity that is not present.
- Pie or doughnut: Show parts of one whole when there are only a few categories and the values are comparable. Many slices or similar-sized slices make precise comparisons difficult.
- Scatter (XY): Compare two numerical variables, with one numeric measure on each axis. This is different from a line chart, which commonly treats horizontal-axis entries as categories.
- Area: Emphasize totals or magnitude over an ordered sequence. Overlapping filled areas can make individual series hard to distinguish.
- Combo: Combine chart types, such as columns for sales and a line for a target. A secondary axis may help when scales differ, but it can also make the visual relationship misleading if the axes are not clearly labeled.
For example, to compare sales for five product categories in one quarter, a bar or column chart is usually more direct than a pie chart if readers need to rank the categories. To show sales across twelve months, a line chart can make the direction of change easier to follow. If the goal is to investigate whether advertising spending and sales move together, a scatter chart is a more suitable starting point than a line chart.
Format and Explain the Chart
Formatting should help someone interpret the data, not decorate it at the expense of clarity. Give the chart a specific title, such as “Monthly sales by product, 2025,” rather than a generic heading such as “Chart.” Add axis titles when units or measures might be unclear. A vertical axis labeled “Revenue (dollars)” is more informative than one labeled only “Revenue.”
Select the chart to use controls on the Chart Design tab, including options for adding chart elements, changing layout or colors, and switching rows and columns. Depending on the chart and Excel build, the Chart Elements button beside the chart can also provide quick access to items such as titles, legend, and data labels. To edit wording, select the title or label and type the replacement. To change a series or source range, use Chart Design > Select Data.
Use data labels when exact values matter, but avoid placing so many labels that they collide. A legend is useful when several series need identifying; with one series, a clear title and axis labels may be enough. Keep colors consistent, use strong contrast, and do not rely on color alone to distinguish important categories. For printed or shared charts, check that the text remains readable at the intended size.
Axis settings can change how a chart feels. A value axis that starts above zero can exaggerate modest differences in a bar chart, because bar lengths are visually compared from their baseline. A line chart may use a narrower scale for a legitimate close-up view, but the scale should be clear and the choice should match the purpose. Right-click an axis and choose Format Axis to inspect its settings; the available options depend on the chart type.
Common Chart Problems and Fixes
If Excel plots the wrong categories or series, select the chart and use Chart Design > Switch Row/Column or Chart Design > Select Data to review the source range, series names, and category labels. If dates appear as separate text categories or in an unexpected order, check that the source cells contain actual Excel dates and inspect the axis settings.
A chart that omits a new row may not include that row in its source range. Review the range through Select Data, or consider using a well-structured Excel table as the source for data that expands. A chart with gaps may reflect blank cells, missing values, or formulas that return an empty string. Excel’s treatment of empty cells can be adjusted in the Select Data dialog through Hidden and Empty Cells, where available; choose a display that honestly represents missing information rather than implying values were measured.
Other frequent issues include:
- Unhelpful chart type: A pie chart with many categories is hard to compare. Use a bar chart or group categories when the purpose allows.
- Unreadable labels: Widen the chart, shorten category names, rotate labels if appropriate, or use a horizontal bar chart.
- Unexpected totals: Remove subtotal rows from the selected range or verify that the chart is not counting them as an additional category.
- Misleading scales: Check axis minimums, maximums, and units, particularly when using a secondary axis.
- Too much visual clutter: Remove unnecessary gridlines, borders, effects, and labels so the main comparison stands out.
Charts, PivotCharts, and Alternatives
A standard chart is suitable when the source is a relatively simple range or table and the layout is manageable. A PivotChart is connected to a PivotTable and is useful when readers need to summarize or explore larger data sets by categories such as region, product, or date. To create one, select the data and choose Insert > PivotChart; Excel guides you through creating or choosing a PivotTable and placing the chart. The field list and available interactions differ from those of a standard chart because the visual is tied to the PivotTable summary.
Not every visual belongs in a chart. Conditional formatting can highlight values directly in a grid, which is helpful when the reader needs the underlying numbers alongside a quick visual cue. A PivotTable can summarize data without a chart. For a simple report, a carefully formatted table may be clearer than a graphic, especially when readers must look up exact figures rather than recognize a pattern.
Excel also offers specialized chart types, including histogram, waterfall, treemap, and statistical charts, though availability and options can vary by Excel version and platform. If a particular chart is unavailable or behaves differently in a recipient’s version, consider whether a common bar, line, or scatter chart can communicate the same point more reliably. For interactive dashboards or shared web reporting, Power BI or another dedicated visualization tool may offer capabilities beyond a worksheet chart, but it also requires a different workflow.
Sharing and Maintaining Charts
A chart can be copied into another Office document or shared as part of the workbook. When copying, consider whether the destination should contain an editable chart linked to workbook data or a static image. A linked or embedded chart can preserve editability, while an image is less likely to change but does not update when the source data changes. The paste options shown by Office determine what is available for a particular copy operation.
Before sharing a workbook, confirm that the chart title, units, date range, and source data are understandable without spoken explanation. Check that filters or hidden rows have not produced an unexpected view, and consider how the chart looks at normal zoom and in print or PDF. If the chart supports a recurring report, document the source range and refresh steps so another person can maintain it. A polished chart is only dependable when its data and assumptions remain clear.
Frequently Asked Questions
What is the difference between a chart and a graph in Excel?
People commonly use the terms to mean the same thing. Excel generally calls its visualizations charts, and the chart menu includes graph-like options such as line and scatter charts.
How do I make a chart update when I add data?
Create the chart from an Excel table when practical, then add records within the table so the source can expand with it. If the chart still omits new values, check its range with Chart Design > Select Data.
Which Excel chart is best for comparing categories?
A bar or column chart is a strong default for comparing category values. A horizontal bar chart is often easier to read when category labels are long; choose the final type based on the data and the comparison you want to emphasize.
Can I make a chart from non-adjacent cells?
Yes. Select the first range, then hold Ctrl on Windows while selecting additional ranges, where the layout allows, and insert the chart. If Excel arranges the series incorrectly, use Select Data to adjust the series and labels.
Why does my Excel chart show blank spaces?
Blank source cells, missing observations, or formulas returning empty text can create gaps. Inspect the source data and the chart’s Hidden and Empty Cells settings, and choose a display that does not suggest missing measurements are known values.
Can I use Excel charts in Excel for the web?
Yes. Excel for the web can create and edit many charts, but some advanced formatting controls and workflows differ from desktop Excel. If a needed option is missing, open the workbook in the desktop app and check the chart there.
Related
- Power Query Editor: What It Is, How It Works, and Why
- Excel Data Validation Icon: What It Looks Like and Does
- Data Validation Multiple Selection in Excel: What Works
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Excel Line Chart: Change X-Axis ValuesTo change the x-axis labels on an Excel line chart, select the chart, choose Chart Design > Select…
- Insert a Linked Excel Chart in PowerPoint: Keep It UpdatedTo insert a linked Excel chart in PowerPoint for Microsoft 365 on Windows, select the chart in Excel…
- Excel Pie Chart Labels on Slices: How to Add ThemTo put labels directly on pie slices in Excel for Microsoft 365 on Windows, select the chart, then…
- Does Excel Have a Gantt Chart? How to Make OneExcel does not include a dedicated Gantt chart type, but you can make a useful Gantt-style schedule in…
- Create an Excel Dashboard With Free AI ToolsYes—you can create an Excel dashboard with free AI tools by asking a free AI assistant to help…
- Excel Box Plot X-Axis: Categories, Labels, and FixesIn an Excel box plot, the x-axis normally shows the categories or data groups being compared; the y-axis…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.