Excel Chart Maker: Create, Format, and Choose Charts

Excel’s built-in chart maker turns selected worksheet data into a chart: select a well-organized range, then choose Insert > Recommended Charts and pick a chart. Excel for Microsoft 365 on Windows also lets you choose a chart type directly from the Insert tab. From there, you can adjust its data, labels, colors, and layout without leaving the workbook.

What “Excel chart maker” means

“Excel chart maker” usually means Excel’s chart-creation tools, not a separate Microsoft product. Charts are visual representations of worksheet data, linked to the cells they use. If a source value changes, the chart can reflect that change; if you change the chart’s source range, you can add or remove the data it displays.

A chart is useful when a reader needs to see a comparison, pattern, or distribution more quickly than they could by scanning a table. For example, a table of monthly sales figures contains the exact numbers, while a column chart makes differences between months easier to spot. A chart should clarify the data rather than decorate it: a title, sensible scale, and clear labels usually matter more than elaborate effects.

Excel can create standard charts such as column, bar, line, pie, scatter, area, and doughnut charts, as well as options such as histogram, waterfall, and combo charts. The available choices depend partly on the type and arrangement of data. Excel’s Recommended Charts feature examines the selected range and suggests chart types, but its suggestion is a starting point, not a guarantee that the chart communicates the point you intend.

Prepare the worksheet before creating a chart

Good chart results start with a tidy source range. Put each category or date in one column and each measured series in its own column. Use a single header row, avoid blank rows or columns inside the data, and keep units consistent. For example, a monthly sales table might have Month, Online sales, and Store sales as headers, followed by one row for each month.

Excel often interprets the first row and first column as labels automatically. Clear headings help it make that choice correctly. If the range contains unrelated notes, subtotals, or multiple header rows, Excel may plot those as data or omit values. Select only the cells that belong in the chart. You can include the header cells so Excel uses them for the legend and axis labels.

Think about what each row represents before charting. A list of product names with one sales value per product is a category comparison. A series of dates and measurements is usually a time trend. If the table has several measures with very different units, such as revenue and percentage margin, plotting them on one scale can make one series appear nearly flat. That may call for a combo chart with a secondary axis, or two separate charts.

Create a chart in Excel for Microsoft 365 on Windows

Select the cells containing the data and, where appropriate, the headers.
Open the Insert tab and choose Recommended Charts. In the dialog, review the suggestions or select the All Charts tab to browse chart types.
Choose a chart and select OK. Excel inserts it into the worksheet; drag its border to reposition it and use the corner handles to resize it.
Click the chart to reveal the contextual Chart Design and Format tabs. Use those tabs to change the chart type, data source, layout, and appearance.

You can also choose a chart type from the chart controls on the Insert tab without opening Recommended Charts. The exact arrangement of controls can vary with the ribbon window size. For a quick first look, select the range and press Alt+F1 on Windows to insert a chart in the current worksheet. The result uses Excel’s default chart choice, so review whether the selected type and included data make sense.

On Mac, chart creation is also available from the Insert tab, though ribbon placement and some keyboard shortcuts differ. Excel for the web can create and edit many common charts, but some advanced formatting and chart features may be limited compared with the desktop app. If a command is missing in the web version, opening the workbook in desktop Excel may provide the fuller set of controls.

Choose a chart type that fits the question

Choose based on the relationship you want the reader to notice, not simply on the visual style you like. A few practical matches are:

Column or bar: Compare values across categories. Use a bar chart when category names are long; horizontal labels are easier to read.
Line: Show change across an ordered sequence, especially dates. Several lines can compare trends, provided the series are not too numerous or visually crowded.
Scatter: Examine the relationship between two numeric variables, such as advertising spend and orders. Unlike a line chart, a scatter chart treats both axes as numeric values.
Pie or doughnut: Show how a small number of categories make up one whole. These charts are harder to compare precisely, so avoid them when there are many slices or when values are close.
Histogram: Show the distribution of numeric observations by grouping them into bins. It answers a different question from a column chart of named categories.
Combo: Display different kinds of measures together, such as sales dollars and a percentage rate. A secondary axis can help with different scales, but label it clearly so viewers do not mistake the relationship.

For example, if a worksheet lists monthly revenue and monthly order count, two lines may show whether the measures rise and fall together. If the magnitudes differ greatly, a combo chart can place one series on a secondary axis. However, two separate charts may be clearer: separate axes can make visual comparisons seem stronger or weaker depending on their scales. Avoid 3-D effects when they distort apparent sizes or make values difficult to compare.

Format and label a chart

Select a chart to work with its contextual tabs. On the Chart Design tab, useful controls include Add Chart Element, Quick Layout, Change Colors, Switch Row/Column, Select Data, and Change Chart Type. Add Chart Element is where you can add items such as a chart title, axis titles, data labels, or a legend. The Format tab provides controls for selected chart elements, including fill, outline, and text formatting.

Use a title that states what the chart measures and, if needed, the time period. Axis titles should name the measure and units, such as “Revenue (USD)” or “Temperature (°C).” Data labels are helpful when readers need exact values, but displaying every number can clutter a chart with many points. A legend is useful when a chart has multiple series; with one series, it may be unnecessary.

Keep formatting consistent and restrained. Use color to distinguish series or draw attention to a meaningful point, not as the only way to communicate a difference. Check contrast, font size, and whether the chart remains understandable when printed in grayscale. For a workbook shared with others, add alternative text where available and provide a nearby table or written summary if the values themselves are important.

Make charts easier to update

If the source data will grow, format it as an Excel table before creating the chart: select the range and use Insert > Table, confirming whether the data has headers. Charts based on a table can often include new rows as the table expands, which is more convenient than repeatedly editing a fixed cell range. Still, verify the chart after adding data, especially if new columns or irregularly placed rows are involved.

To change what an existing chart displays, select it and choose Chart Design > Select Data. In the Select Data Source dialog, you can revise the chart data range, add or remove a series, or adjust category labels. Switch Row/Column changes whether Excel treats rows or columns as separate series; it can quickly fix a chart that has the right numbers but the wrong grouping.

For a chart that needs to be reused in a report, keep its source data and chart together in the workbook when possible. If you copy a chart elsewhere, check whether it remains linked to the original workbook or uses data copied into the destination. The behavior can depend on how you copy and paste and on the destination application. A pasted image is different: it will not update when the worksheet values change.

Common chart problems and fixes

Excel plots the wrong groups: Select the chart and choose Chart Design > Switch Row/Column. If the result is still wrong, open Select Data and check the range and series names.
Some values are missing: Check that the source cells contain numbers rather than numbers stored as text, and confirm that the chart range includes the missing rows. In Select Data Source, use Hidden and Empty Cells to review how blanks and hidden data are handled.
Dates appear as unrelated labels: Check that the source cells are actual Excel dates and inspect the horizontal axis settings. A date axis can space dates according to time; a text axis treats entries as categories.
The chart looks flat: A very large value or an inappropriate axis minimum may compress the other values. Review the axis scale and confirm whether an unusual data point is valid before changing the scale.
New rows do not appear: Check whether the chart’s source range includes them. Using a formatted Excel table can make routine additions easier, but confirm that the chart references the table’s expanded data.

Be cautious about changing an axis minimum just to make small differences look dramatic. A truncated axis can be useful in some specialized charts, but it can also exaggerate changes. If you adjust a scale, make that choice visible and ensure the visual impression remains fair.

Excel charts versus other chart makers

Excel is a practical chart maker when the data is already in a workbook, needs frequent updates, or must be analyzed alongside formulas and tables. Its charts remain connected to spreadsheet cells, and the workbook can contain both the underlying figures and the visual. For common business, school, and personal uses, that integration is often more important than having a large library of decorative templates.

Presentation software can be more convenient when the main task is arranging visuals on slides, while dedicated visualization tools may offer specialized dashboards, interactive filtering, or connections to larger data sources. Online chart makers can also be useful for a quick graphic, but may require uploading data. Before using an external service, consider whether the worksheet contains confidential or personal information and check the service’s data-handling terms.

Excel is included with Microsoft 365 plans that provide the desktop app, while the available features and access depend on the license and whether you use desktop or web Excel. There is no separate Excel chart-maker fee beyond the Excel access you already have. Organizations should check their Microsoft plan and policies; people choosing a new tool should compare collaboration, export, accessibility, and data-privacy requirements as well as chart appearance.

Frequently Asked Questions

Is Excel a free chart maker?

Excel has built-in chart tools, but access depends on how you use Excel and the Microsoft license available to you. Some users have desktop Excel through a paid Microsoft 365 plan or another license; Excel for the web may be available with a Microsoft account, with feature differences. Check Microsoft’s current plan details for your region rather than assuming every chart feature is available for free.

How do I make a chart from two columns in Excel?

Put category labels in one column and the corresponding numeric values in the next, include a header row if possible, and select both columns. Choose Insert > Recommended Charts, select a suitable chart, and choose OK. If Excel assigns the labels or series incorrectly, use Chart Design > Select Data to correct them.

Can an Excel chart update when I change the data?

Yes. A chart linked to worksheet cells normally reflects changes to those source values. If you add new rows, the chart may not include them unless its range expands; using an Excel table as the source can help. A chart pasted as a picture is static and will not update from the cells.

Which Excel chart is best for comparing months?

A line chart is a common choice for showing a trend across months, while a column chart emphasizes differences between individual months. Use a line when continuity and direction matter; use columns when comparing discrete periods is the priority. Label the time period and units, and avoid adding so many series that the chart becomes difficult to read.

Why is my Excel chart blank?

Check that the chart points to the intended range, that numeric values are stored as numbers, and that the rows are not excluded or hidden under the chart’s current settings. Select the chart and open Chart Design > Select Data to inspect the source. Blank cells, text values, or a range containing only headings can leave a chart empty or incomplete.

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.