How to Create Charts in Excel: Step-by-Step Guide

Charts & pivot tables · Updated November 22, 2026

Creating a chart in Excel turns rows of numbers into a visual story, making trends and comparisons instantly clear. The fastest way is to select your data and press Alt+F1 (Windows) or Fn+Option+F1 (Mac) to insert a default column chart, then use the Chart Design tab to refine it. This guide walks you through the full process, from selecting data to customizing and troubleshooting, so you can build professional charts with confidence.

What You’ll Need

  • Microsoft Excel (Microsoft 365, Excel 2021, 2019, or 2016 for Windows; Mac versions work similarly with noted differences).
  • A dataset with at least two columns or rows of related data (e.g., months in column A, sales in column B).
  • Basic understanding of selecting cells and using the ribbon.

Step-by-Step

  1. Prepare your data. Ensure your data is in a clean table format: headers in the first row (e.g., “Month”, “Sales”), and no blank rows or columns within the range. Avoid merged cells in the data area.
  2. Select the data range. Click and drag to highlight the cells that include both the labels (like months) and the values (like sales). Include the header row if you want Excel to use those as series names and axis labels. For example, select A1:B13.
  3. Insert a chart. Go to the Insert tab on the ribbon. In the Charts group, you’ll see icons for Column, Line, Pie, Bar, Area, and more. Click the chart type you want, then choose a subtype (e.g., “Clustered Column”). Alternatively, use the Quick Analysis button that appears at the bottom-right of your selection (Windows only) and click Charts to pick a style.
  4. Use the keyboard shortcut (optional). Press Alt+F1 on Windows to instantly insert a clustered column chart on the same sheet. On Mac, press Fn+Option+F1 (or F11 if function keys are set to standard).
  5. Move or resize the chart. Click the chart to select it. Drag it to a new location on the sheet, or drag the corner handles to resize. To move the chart to its own sheet, right-click the chart and choose Move Chart, then select New sheet.
  6. Change the chart type. If the default chart isn’t right, click the chart, then go to the Chart Design tab (which appears when the chart is selected). Click Change Chart Type and pick a different type (e.g., switch from column to line).
  7. Edit the chart title. Click the chart title text box (usually says “Chart Title”) and type your own title. To format it, right-click the title and choose Format Chart Title to change font, color, or position.
  8. Add or remove chart elements. Click the chart, then click the + (plus) button that appears at the top-right corner of the chart (Windows) or use the Chart Elements button in the Chart Design tab. Check or uncheck items like Data Labels, Axis Titles, Legend, and Gridlines.
  9. Format axes and data series. Right-click an axis (like the vertical value axis) and choose Format Axis to adjust minimum/maximum bounds, number format, or tick marks. Right-click a data series (the colored bars or lines) to change fill color, add a trendline, or adjust gap width.
  10. Apply a chart style. With the chart selected, go to the Chart Design tab and browse the Chart Styles gallery. Click a style to instantly change colors and effects. You can also use the Format tab for more granular styling.
  11. Save and share. Save your workbook as usual (Ctrl+S on Windows, Cmd+S on Mac). To copy the chart into a Word document or PowerPoint slide, click the chart, press Ctrl+C (or Cmd+C), then paste in the destination. Choose Use Destination Theme & Embed Workbook for easy editing later.

Common Mistakes

  • Selecting blank rows or columns: Including empty cells can create gaps or extra series. Always select only the data you need.
  • Using non-adjacent data without holding Ctrl: If your data isn’t in one block, hold Ctrl (or Cmd on Mac) while selecting multiple ranges. But this can confuse Excel; better to reorganize data into one block.
  • Choosing the wrong chart type: For example, using a pie chart for data that changes over time (use a line chart instead) or using a line chart for categories (use a column chart).
  • Forgetting to update the chart when data changes: If you add new rows below the original range, the chart may not include them. Use a table (Ctrl+T) or update the data range manually.
  • Overcomplicating with too many series: A chart with 15 series becomes unreadable. Simplify or use a pivot chart.

Tips

  • Use Excel Tables: Convert your data range to a table (select data, press Ctrl+T). Charts based on tables automatically expand when you add new rows.
  • Leverage Recommended Charts: On the Insert tab, click Recommended Charts to see Excel’s suggestions based on your data pattern.
  • Use the Format Pane: Double-click any chart element to open the Format pane on the right, giving you precise control over colors, sizes, and effects.
  • Add a trendline: For a scatter or line chart, right-click a data series and select Add Trendline to show patterns like linear or moving average.
  • Save as a template: If you create a chart style you like, right-click the chart and choose Save as Template. Then you can apply it to future charts via the Change Chart Type dialog’s Templates folder.
  • Keyboard shortcut for new chart: Press F11 (Windows) to create a chart on a new sheet instantly. On Mac, it’s Fn+F11.

Troubleshooting

  • Chart looks empty or shows only one series: This usually means Excel didn’t recognize your data correctly. Click the chart, go to Chart Design > Select Data. In the dialog, check the Chart data range field. Adjust it to include all cells. Also ensure the Legend Entries (Series) list has the correct series names.
  • Axis labels are numbers instead of text: Excel may be interpreting your labels as a data series. In Select Data, click Edit under Horizontal (Category) Axis Labels and select the correct range that contains your labels.
  • Chart doesn’t update when I change data: If the chart is not based on a table, it only updates if the data range is correct. Check the range in Select Data. If you added rows, expand the range. Alternatively, convert to a table.
  • Pie chart shows percentages that don’t add to 100%: This happens if you included a total row in your data. Remove the total row from the selected range.
  • Legend shows “Series1” instead of your headers: This occurs when you didn’t include the header row in your selection. Re-select the data including the headers, or edit the series name in Select Data.
  • Chart is too small or distorted: Click the chart and drag the corner handles while holding Alt (Windows) to snap to cell gridlines, or simply resize manually.

Frequently Asked Questions

  • How do I create a chart from non-adjacent columns? Hold Ctrl (or Cmd on Mac) while selecting each column. Then insert a chart. Excel will combine them, but it’s often easier to copy the columns next to each other first.
  • Can I create a chart in Excel for the web? Yes. In Excel for the web, select your data, go to Insert > Charts, and pick a type. The options are more limited than desktop, but you can still create, edit, and format basic charts.
  • How do I change the colors of a chart to match my brand? Select the chart, go to the Format tab, and choose a different color from the Shape Fill for each series, or use the Chart Styles gallery for preset palettes. For a full custom theme, right-click the chart area and choose Format Chart Area to set fill and border.
  • Why does my line chart have gaps for missing data? Excel plots gaps as blank spaces. To connect the gaps, right-click the chart, choose Select Data, click Hidden and Empty Cells, and select Connect data points with line.
  • How do I add a secondary axis for two different scales? Select the data series you want on the secondary axis (click the series line or bar), right-click, and choose Format Data Series. Then select Secondary Axis. This is useful when combining e.g., revenue and profit margin.
  • Can I create a chart from a pivot table? Yes. Click anywhere inside the pivot table, go to PivotTable Analyze > PivotChart, and choose a chart type. The chart will update as you filter the pivot table.

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.