How to Make a Graph in Excel: Step by Step Guide

Excel is a powerful tool for organizing and analyzing data, and one of its most common uses is for creating graphs and charts. However, if you're new to Excel, the process of making a graph can seem overwhelming. In this step-by-step guide, I'll walk you through the process of creating a graph in Excel, from choosing the data to formatting the final product. Let's get started!

Step 1: Choose Your Data

The first step in creating a graph in Excel is to choose the data you want to represent. Your data should be organized in columns or rows, with each column or row representing a different category or variable. For example, if you're creating a graph to show monthly sales figures, you could organize your data with the months in one column and the sales figures in another column.

It's important to choose data that will create a clear and compelling graph. If your data is too complex or difficult to interpret, your graph will be confusing and unhelpful.

Step 2: Insert the Graph

Once you've chosen your data, it's time to insert your graph. To do this, click on the "Insert" tab in the Excel menu, and select the type of graph you want to create. Excel offers a variety of graph types, including bar graphs, line graphs, and pie charts, so choose the one that best represents your data.

Once you've selected your graph type, Excel will insert a blank graph into your worksheet. You can now begin to customize the graph to fit your data and your needs.

Step 3: Customize the Graph

Now that you have a blank graph inserted into your worksheet, it's time to customize it to fit your data and your needs. You can customize your graph in a number of ways, including changing the axis labels, adding a title, and changing the colors.

To change the axis labels, click on the axis label you want to change, and then type in your new label. To add a title, click on the "Chart Title" box and type in your new title. To change the colors, click on the "Format Chart Area" option and select the colors you want to use.

It's important to customize your graph to fit your needs, while still keeping it clear and easy to read. Avoid using too many colors or making your graph too complex, as this can make it difficult to understand.

Step 4: Add Data Labels (Optional)

If you want to make your graph even clearer, you can add data labels to show the exact values of each data point. To do this, click on the "Data Labels" option in the Excel menu and select the type of label you want to use.

Data labels can be helpful for showing precise values, but it's important to use them sparingly. If you add too many data labels, your graph can become cluttered and confusing.

Step 5: Save and Share Your Graph

Once you've customized your graph to fit your needs, it's time to save it and share it with others. To save your graph, simply click on the "Save" button in the Excel toolbar, and choose the format you want to use.

If you want to share your graph with others, you can either share the Excel file or copy and paste the graph into another document. To copy and paste the graph, simply select the graph and use the "Copy" and "Paste" commands in your document of choice.


Creating a graph in Excel can seem daunting at first, but by following these simple steps, you can create a clear and compelling graph that effectively communicates your data. Remember to choose your data carefully, customize your graph to fit your needs, and share your graph with others to communicate your findings. With a little practice, you'll be a graph-making pro in no time!

By clicking “Accept”, you agree to the storing of cookies on your device to enhance site navigation, analyze site usage, and assist in our marketing efforts. View our Privacy Policy for more information.