Chi Uni logo full colour blue rgb

Excel – Charts and Graphs

1 min read

Creating Charts & Graphs in Excel

Excel lets you transform rows and columns of data into insightful visuals. Use charts to make trends, comparisons, and patterns instantly clear. Here’s how to create and customize a variety of chart types.

Step 1: Prepare Your Data

  • Organize your data in a clear table format, including headers for each column.
  • Ensure that each column represents a single data series (e.g., sales amounts, dates, categories).
  • Avoid mixing incompatible formats (e.g., text and numbers) in the same column.
This image shows a table in excel with heading along the top and each data category seperated

Step 2: Insert a Chart

  1. Select the data you want to visualize, including headers.
  2. Open the Insert tab and click Recommended Charts.
    • On the Recommended tab, hover over any suggestion to preview it.
    • If nothing suits, select All Charts to explore every option.
  3. Click the desired chart and press OK.
    Excel will insert it onto your worksheet
This image shows the insert recommended chart button when you have data selected

Step 3: Customize with Chart Tools

Click the chart to activate additional tools:

  • Chart Elements: Add titles, data labels, gridlines, axes, and legends.
  • Chart Styles: Choose color schemes and overall chart looks.
  • Chart Filters: Control which data series or categories are visible.
  • Design & Format Tabs: Access advanced formatting and layout adjustments.
This image shows the add chart element button being used on the side of a selected chart.

Step 4: Chart-Specific Setup

  • Bar Charts:
    1. Ensure headers are included.
    2. Insert a clustered or stacked bar/column chart.
    3. To add another series: right-click the chart > Select Data… > Add under Legend Entries (Series).
  • Line or Scatter Charts:
    1. Suitable for numeric or date-based X-axis.
    2. Insert via Recommended Charts.
    3. Use Select Data… to fine-tune series
  • Radar Chart:
    1. Set data up with category names and values per row.
    2. Select range, go to All Charts, and choose Radar
This picture displays a radar chart
  • Pie Chart:
    1. Organize your data in two columns: category and value.
    2. If using log-format data, pre-aggregate with =COUNTIF or SUMIF.
    3. Select the summary table and insert a Pie chart.
  • Sunburst Chart:
    1. Prepare data in hierarchical order: primary category, secondary category, then values.
    2. Select the full table, go to All Charts, and pick Sunburst.
  • Waterfall Chart:
    1. Calculate changes over time in your data table.
    2. Select the time and change columns (use Ctrl-click for non-adjacent columns).
    3. Go to All Charts via Recommended Charts, and choose Waterfall.
This image shows a waterfall chart

Step 5: Advanced Options

  • Add or remove data series by right-clicking the chart and selecting Select Data.
  • Change the calculation or grouping using Chart Filters.
  • Apply trendlines for analysis (right-click a data series → Add Trendline).
  • Use combo charts for complex data comparisons.
Was this article helpful?
Updated on January 12, 2026