How to Make a Chart in Excel: A Step-by-Step Guide for Beginners

Creating a chart in Excel is a breeze once you know the steps. You’ll start by selecting your data, choosing the type of chart that best represents your information, and then customizing it to fit your needs. This article will walk you through the process in a detailed, easy-to-follow manner, making sure you can create eye-catching and informative charts in no time.

Step-by-Step Tutorial: How to Make a Chart in Excel

Creating a chart in Excel will help you visualize data effectively. Follow these steps to create a customized chart that highlights your data points clearly and efficiently.

Step 1: Open Excel and Select Your Data

Open your Excel spreadsheet and highlight the data you want to include in your chart.

Selecting your data is the foundation of your chart. Make sure you include both the labels (like months or product names) and the actual data points (like sales numbers).

Step 2: Click on the ‘Insert’ Tab

Go to the top of the Excel window and click on the ‘Insert’ tab.

The ‘Insert’ tab is your gateway to all the chart options Excel offers. Once you’re there, you’ll see a variety of chart types to choose from.

Step 3: Choose Your Chart Type

Click on the chart type that best fits your data, such as bar, line, pie, etc.

Different data sets call for different types of charts. For example, use a pie chart to show percentages or a line chart to illustrate trends over time.

Step 4: Customize Your Chart

Once the chart is inserted, use the ‘Chart Tools’ to customize it by adding titles, labels, and changing colors.

Customizing your chart makes it more readable and visually appealing. You can add axis titles, change the chart style, and even insert data labels directly onto the chart.

Step 5: Save Your Work

Save your Excel file to ensure you don’t lose your newly created chart.

You’ve put in the effort to create a fantastic chart, so don’t forget to save your work. Click on ‘File’ and then ‘Save As’ to store your file in a secure location.

After following these steps, your chart will appear within your Excel spreadsheet, making your data easy to understand at a glance.

Tips for Making a Chart in Excel

  • Select Appropriate Data: Ensure your data is clean and organized before creating your chart.
  • Choose the Right Chart Type: Different types of charts serve different purposes. Pick the one that best fits your data.
  • Use Descriptive Titles and Labels: Clear titles and labels help your audience understand the chart quickly.
  • Customize for Clarity: Adjust colors, fonts, and other elements to make your chart as clear as possible.
  • Check Your Data: Always double-check your data for accuracy before finalizing your chart.

Frequently Asked Questions about Making a Chart in Excel

How do I change the chart type after creating it?

Click on your chart, then go to the ‘Chart Tools’ menu and select ‘Change Chart Type.’

Can I add data to an existing chart?

Yes, you can. Right-click on the chart, choose ‘Select Data,’ and then add your new data range.

How do I format the axis labels?

Click on the axis labels, then use the ‘Format Axis’ options to customize the font, size, and color.

Is it possible to create a chart with two different data series?

Yes, you can add multiple data series by selecting additional columns of data when you create your chart.

How do I make my chart more visually appealing?

Use the ‘Chart Tools’ to add colors, effects, and styles that make your chart more engaging and easier to read.


  1. Open Excel and select your data
  2. Click on the ‘Insert’ tab
  3. Choose your chart type
  4. Customize your chart
  5. Save your work


Creating a chart in Excel is a straightforward process that can greatly enhance the way you present data. By following these easy steps, you’ll be able to create a chart that not only looks good but also effectively communicates your message. Remember, the key to a great chart is in the details, so take the time to customize it to fit your needs.

Excel charts are powerful tools that can transform raw data into insightful visuals. Whether you’re creating a sales report, tracking marketing metrics, or presenting research findings, a well-crafted chart can make all the difference. So go ahead, open Excel, and start turning your data into compelling stories today!

For further reading, check out Microsoft’s official Excel support page or explore online tutorials for more advanced charting techniques. Happy charting!

Get Our Free Newsletter

How-to guides and tech deals

You may opt out at any time.
Read our Privacy Policy