How to Prepare Graph in Excel: Step-by-Step Guide to Master Chart Creation

Creating graphs in Excel can be a piece of cake once you know the steps. You start by entering your data, select it, and then use Excel’s built-in chart tools to visualize that data. Whether you’re making a bar graph, line chart, or pie chart, Excel has got you covered. Follow the guide below, and you’ll be graphing like a pro in no time.

How to Prepare Graph in Excel

Creating a graph in Excel helps you to visualize data, making complex information easier to understand. Here’s a step-by-step guide to help you create one.

Step 1: Open Excel

Just fire up the Excel application on your computer.

When you open Excel, you’re greeted by a blank workbook. This is where the magic begins.

Step 2: Enter Your Data

Type your data into the cells. Each column will represent a different variable.

For instance, if you want to compare sales over months, enter the months in one column and the sales numbers in the next.

Step 3: Select Your Data

Click and drag to highlight the data you want to include in your graph.

Ensure you include the headers (like "Month" and "Sales") to make your graph more informative.

Step 4: Go to the Insert Tab

Click on the ‘Insert’ tab located on the Ribbon at the top of the screen.

This tab is your gateway to all the different types of graphs you can create in Excel.

Step 5: Choose Your Graph Type

Select the type of graph you want to create from the Charts group.

Popular options include bar graphs, line charts, and pie charts. Choose one that best fits your data.

Step 6: Customize Your Graph

Click on your graph to access the Chart Tools. You can add titles, labels, and change colors.

Customization makes your graph easier to read and more visually appealing.

Step 7: Save Your Work

Don’t forget to save your Excel file.

You can save it by clicking the ‘File’ tab and selecting ‘Save As.’ Choose a location and file name, and you’re done.

After completing these steps, you’ll see a polished graph representing your data. It’s a powerful visual tool, and you can tweak it as much as you want to make it perfect.

Tips for Preparing a Graph in Excel

  • Use clear and simple data labels to make your graph easy to understand.
  • Always double-check your data for accuracy before creating the graph.
  • Choose the graph type that best represents your data to avoid confusion.
  • Take advantage of Excel’s customization features to make your graph stand out.
  • Save your work frequently to avoid losing any progress.

Frequently Asked Questions

How do I change the chart type after creating a graph?

Right-click on the graph and select ‘Change Chart Type.’ Then choose a new type from the list.

Can I add more data to an existing graph?

Yes, click on the graph, then drag to highlight the additional data you want to include.

How do I format the axis labels?

Click on the axis labels, then use the options in the Chart Tools Format tab to customize them.

Is it possible to create a 3D graph?

Absolutely! When you choose your chart type, you’ll see options for 3D graphs in the list.

Can I copy my graph to another document?

Yes, you can copy and paste your graph into other documents like Word or PowerPoint.


  1. Open Excel
  2. Enter Data
  3. Select Data
  4. Go to Insert Tab
  5. Choose Graph Type
  6. Customize Graph
  7. Save Work


Creating graphs in Excel isn’t just for the math wizards or data scientists; anyone can do it with a bit of guidance. By following the steps outlined above, you’ll be able to turn your raw data into a visual masterpiece that’s easy to understand and share.

Graphs are not merely visual aids—they are powerful storytelling tools that make your data come alive. When you prepare a graph in Excel, you’re not just compiling numbers; you’re providing insight that can inform decisions and spark conversations.

So, get into Excel and start experimenting. The more you practice, the more intuitive it will become. Before you know it, you’ll be crafting graphs that not only wow your audience but also make complex data accessible to everyone. Happy graphing!

Get Our Free Newsletter

How-to guides and tech deals

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