Excel Graphs for Beginners: How to Choose and Make Them

Charts & pivot tables · Updated November 17, 2026

Excel graphs—called charts in Excel—turn rows of worksheet data into a visual summary. To make one in Microsoft Excel for Microsoft 365 on Windows, arrange your data in a labeled table, select the cells, choose Insert > Recommended Charts, pick a chart, and select OK; then use the Chart Design and Format tabs to refine it.

What an Excel graph does

A chart represents worksheet values visually so you can compare categories, follow change over time, or see how two measurements relate. Excel uses the word “chart” for this feature, although many people casually call the result a graph. A chart is linked to its source cells: when those values change, the chart can update too.

Charts are useful when a visual comparison is quicker to understand than a list of numbers. For example, a table can show monthly sales, but a column chart makes a high or low month stand out. A chart does not automatically explain why a value changed, prove that one factor caused another, or make poor-quality data reliable. The person reading it still needs context, clear labels, and an honest scale.

Prepare the worksheet data

Chart creation is easier when the source data has a simple, consistent layout. Put one kind of information in each column, use a descriptive heading in the first row, and keep each record on its own row. Avoid blank rows or columns inside the data block, merged cells, and decorative text in the middle of the table; these can make Excel guess the wrong chart range or interpret a heading as data.

For example, a small comparison table could look like this:

Month Actual sales Sales target
January 42 40
February 35 40
March 48 45
April 51 45

Here, months are categories and the two sales columns are series to compare. Use the same units for values being compared, and make sure dates are stored as dates rather than inconsistent text labels. If your data has subtotals or a grand-total row, leave those out of the chart selection unless they are genuinely part of the comparison. Otherwise, the total can dwarf the individual values and distort the picture.

Choose a chart that fits the question

Start with what you want the reader to notice, not with a favorite visual style. The chart type should make the comparison easy and avoid suggesting a relationship the data cannot support. These are useful starting points:

  • Column or bar chart: Compare values across categories, such as sales by month or responses by department. Columns are vertical; bars are horizontal and can work well when category names are long.
  • Line chart: Show a trend across an ordered sequence, commonly dates or time periods. Lines can help reveal direction and fluctuations, but connecting unrelated categories may imply continuity that is not there.
  • Pie or doughnut chart: Show how a small set of categories contributes to one whole, when the values are parts of the same total. Many slices or similar-sized values are difficult to compare, so a bar chart may be clearer.
  • Scatter chart: Examine the relationship between two numerical measures, such as advertising spend and sales. A pattern can indicate association, not proof that one measure caused the other.
  • Area chart: Emphasize totals or changes over time with filled regions. Overlapping series can hide smaller values, so use it thoughtfully.

For the sample table, a clustered column chart is a reasonable choice: each month gets two adjacent columns, one for actual sales and one for the target. A line chart could also show how both series move across the months. The best choice depends on whether the main point is direct month-by-month comparison or the overall trend.

Create a chart step by step

In Excel for Microsoft 365 on Windows, click a cell in the data block or select the complete range, including its headings. For the sample table, select A1:C5. On the ribbon, choose Insert > Recommended Charts, review the previews, select a suitable option, and click OK. You can also choose a chart directly from the Charts group on the Insert tab, such as Insert Column or Bar Chart, then select a subtype.

Excel places the new chart on the worksheet. Click the chart to reveal chart-specific ribbon tabs, including Chart Design and Format. You can drag the chart to move it and drag a corner sizing handle to resize it. To change what it displays, select Chart Design > Select Data and adjust the chart data range or series. If Excel put months in the legend and sales measures along the horizontal axis, try Chart Design > Switch Row/Column; whether that helps depends on how the source range is arranged.

On a Mac, the ribbon-based chart workflow is broadly similar, though the interface can vary slightly by Excel version. On Excel for the web, chart options are available from the Insert tab but some controls and layout choices differ from the Windows desktop application. If you need a particular design feature, check the menus in the version you are using rather than assuming every desktop command is present.

Format the chart so it is easy to read

A good chart answers the question without making the reader decode unnecessary decoration. Replace the default title with a brief description of the measure, subject, and—when helpful—the time period. For the example, “Actual Sales and Target by Month” is more informative than “Chart Title.” Select the title and type to edit it. Use Chart Design > Add Chart Element to add or change elements such as axis titles, data labels, and a legend.

Check that the category labels and units are understandable. If the vertical axis shows sales in thousands of dollars, say so in an axis title or chart title rather than leaving readers to guess. Keep colors consistent when the same series appears in several charts, and choose combinations with enough contrast. A legend should identify series clearly; direct data labels can be useful for a small chart, but labels on every point may clutter a large one.

Excel may set an axis range automatically. That is often appropriate, but inspect it when a small difference looks dramatic or when a chart starts at a value other than zero. A truncated column-chart axis can exaggerate differences because the columns no longer share a visible zero baseline. A line chart may use a narrower range for legitimate detail, but the scale should be clear and not misleading. You can right-click an axis and choose Format Axis to inspect available bounds and number formatting.

Common problems and how to fix them

When a chart looks wrong, check the data range and series orientation before changing its appearance. A title included as a data point, missing category labels, or an extra blank column can all produce confusing results. Use Chart Design > Select Data to inspect the selected range, series names, and category labels. If the chart excludes new rows added later, consider converting the source range to an Excel table with Insert > Table; charts based on a table can include data added to that table.

  • The chart has the wrong categories: Confirm that the first column contains the labels you want on the category axis, and check Select Data.
  • Numbers appear as separate categories: Check whether numeric values are stored as numbers rather than text, and whether the rows and columns are oriented as intended.
  • A line chart looks jumbled: Use a date or ordered sequence on the horizontal axis, or try a column chart if the categories are unrelated.
  • The chart is hard to read: Reduce the number of series, shorten labels, enlarge the chart, or choose a simpler chart type.
  • The values seem misleading: Review the axis scale, units, filters, and whether the chart includes all relevant data.

Another common misconception is that a 3-D chart is automatically more impressive or informative. Perspective can make it harder to judge values, especially in pie charts, because slices at the front may appear larger. For routine comparisons, a flat two-dimensional chart is usually easier to interpret. Similarly, adding more colors, labels, and effects does not necessarily add useful information.

Keep charts current and share them clearly

If you expect the data to grow, an Excel table is a practical source for a chart. Select the data and choose Insert > Table, confirm whether the table has headers, and use the table as the chart source. Adding a row directly below the table can expand it, and charts linked to the table can reflect added records. Still, verify the chart after structural changes, especially if you move columns, rename headings, or paste data with a different layout.

For a chart that will be read without its worksheet, include enough context in the title and labels to make it understandable on its own. Check the chart at the size it will be displayed; tiny labels that look fine on a large monitor may be unreadable in a report. You can copy a chart into another Office document, or use the chart’s context menu to copy it. Excel also offers chart export options in some versions, but available formats and commands vary, so inspect the options in your current application.

Consider accessibility as well as appearance. Use meaningful titles, readable text, and color contrast; do not rely on color alone to distinguish important information. If the workbook will be shared, keep the underlying data available and provide a brief explanation of key takeaways in nearby text. A chart is a visual aid, not a substitute for accessible labels or the figures needed to verify its message.

Frequently Asked Questions

What is the easiest graph to make in Excel?
A column chart is a straightforward starting point for comparing a few categories. Select a labeled data range, choose Insert > Recommended Charts, and pick the column-chart preview that best matches the comparison.

What is the difference between a graph and a chart in Excel?
Excel’s interface calls the feature a chart. In everyday conversation, people often use “graph” for the same visual, although graph can also refer more specifically to a plotted relationship such as a scatter graph.

How do I change the data in an Excel chart?
Edit the source cells to update their values. To change which cells the chart uses, select the chart and choose Chart Design > Select Data; you can then adjust the range, series, or category labels.

Which Excel chart should I use for dates?
Use a line chart when you want to emphasize a trend over time, or a column chart when comparing separate periods. Make sure the dates are recognized as dates and that the horizontal order is chronological.

Can I make a chart update when I add new data?
Using an Excel table as the source can help a chart include rows added to that table. Check the chart after adding data, because updates depend on how the range and chart series were set up.

Related

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.