Chart & Visualization Issues

How to Create a Graph in Excel: A Simple Guide

Phi Hung Vo Oct 12, 2026 870 views

Question details

The user needs a beginner-friendly guide to creating basic charts or graphs in Excel to visualize their data.

Product: Microsoft Excel
Device & OS: not provided
Scenario: Presenting raw spreadsheet data visually for easier analysis and reporting.
Observed behavior: The user wants to learn the fundamental process of selecting data, choosing a suitable chart type, and applying customizations.

Before you start

Ensure your data is organized in a clear tabular format with distinct column or row headers, and remove any completely blank rows or columns to avoid gaps in your graph.

Solution 1Recommended

Create a Basic Graph Using the Insert Tab

This is the standard method for converting raw spreadsheet data into a visual chart in Excel.

Excel provides a straightforward way to insert various types of charts such as Column, Line, Pie, or Bar graphs directly from the ribbon menu.

Select the Data Range

Click and drag to highlight the cells containing the data you want to visualize. Be sure to include the column and row headers, as these will be used for your axis labels and legend.

Navigate to the Insert Tab

Look at the top ribbon menu in Excel and click on the 'Insert' tab to access the visualization tools.

Choose a Chart Type

In the 'Charts' group, click on the icon for the type of chart you want (e.g., Column, Line, or Pie). Select a specific 2D or 3D format from the dropdown menu to insert it into your worksheet.

Customize the Chart Elements

Click on the newly inserted chart. Use the green plus (+) icon that appears on the right side to add or remove chart elements like the Chart Title, Data Labels, or Axes.

Create a Basic Graph Using the Insert Tab

Dynamic Updates: Your chart is directly linked to the data source. Any changes you make to the selected cells will automatically update the graph.

Create Visuals Easily with WPS Office

Create Beautiful Graphs and Charts in WPS Spreadsheet

WPS Spreadsheet offers a highly intuitive and free way to visualize your data. With full compatibility with Microsoft Excel formats, you can easily insert, customize, and present professional charts without any steep learning curve.

1. Open Your Data: Launch WPS Spreadsheet and open the file containing your raw data.
2. Highlight the Data: Select the data range you wish to chart, making sure to include your headers.
3. Insert the Chart: Go to the 'Insert' tab on the top ribbon and click the 'Chart' button.
4. Select Chart Style: Browse through the categorized chart options in the dialog box and click 'OK' on your preferred style.
5. Format and Customize: Use the quick action buttons beside the chart to quickly modify titles, colors, and data labels.

Fully compatible with Microsoft Excel (.xlsx and .xls) file formats.Rich library of built-in 2D and 3D chart types for any scenario.Smart, one-click chart recommendations based on your selected data.Free, lightweight, and fast office suite available on multiple platforms.

microsoft office alternative - wps office

Frequently Asked Questions

How do I change the chart type after creating it?

Click on your existing chart to select it, go to the 'Chart Design' tab on the ribbon, and click 'Change Chart Type'. From there, you can choose a completely different graph style without needing to reselect your data.

Why is my graph showing blank spaces or zero values?

This usually happens if there are hidden or entirely blank cells within your selected data range. Check your data source to ensure there are no empty rows, or adjust the 'Hidden and Empty Cells' settings in the 'Select Data' dialog.

Can I add a secondary axis to my Excel chart?

Yes, adding a secondary axis is helpful when comparing data with drastically different numerical scales. Right-click the specific data series line or bar on the chart, select 'Format Data Series', and check the box for 'Secondary Axis'.

How do I swap the data on the X and Y axes?

Click on your chart to select it, navigate to the 'Chart Design' tab on the ribbon, and click the 'Switch Row/Column' button. This will instantly swap your axis data.

Excel & Data Problems