Clark Computer Services

How To Make a Graph in Microsoft Excel

Sydney's Seminar

In our last edition of Sydney’s Seminar, we discussed the Pivot Table feature in Microsoft Excel in detail; today, we will add-on to it with How to Make a Graph in Microsoft Excel. Graphs are a great visual to use, especially in presentations or proposals where you need to provide statistics to viewers.

GATHER DATA

The first step to creating your graph is to collect your data in a meaningful way that Excel can interpret. This means that your labels should be clear, and the data should be numerical. Don’t worry if your data isn’t numerical; you can transform it by creating a Pivot Table.

Personally, I find the best way to collect data is to have your independent factor labels in the first column and your dependent factors in the first row.

In this example, I count the dogs with specific coat colors at a doggy daycare. My independent factor is the dog’s colors, which will not vary with the data. My dependent factor will be the variable that does change from case to case, which is the dog count.

How To Make A Graph In Microsoft Excel | Sydney's Seminar | How To Make A Graph In Microsoft Excel | Sydney's Seminar | Sydney’s Seminar – How to Create a Graph In Microsoft Excel gathering data

INSERT GRAPH

Now that we have a complete set of data to review, it’s time to create the graph. To do this, you want to highlight all the data by clicking cell A1 and dragging your cursor to the bottom-right cell of your data (in my case, B7). Then, you will click the “Insert” tab in the top ribbon with the cells highlighted. Navigate to the section that is labeled “Charts” (shown below).

How To Make A Graph In Microsoft Excel | Sydney's Seminar | How To Make A Graph In Microsoft Excel | Sydney's Seminar | Sydney’s Seminar – How to Create a Graph In Microsoft Excel insert graph type

Unless you have a particular graph in mind, it’s best to start with “Recommended Charts.” This tool will show you the graphs that best suit your dataset and provide a preview of what your graph will look like. The type of graphs Excel offers depends on how the data is organized and your overall format.

GRAPHICAL OPTIONS

In the “Recommended Charts” pop-up, you’ll see two tabs up at the top. If you click “All Charts,” you’ll see every possible chart type that you can use to represent your data. In this example, I will be working with a Column Chart, so I will click “Column” in the left-hand options and select my preferred graph. Once I hit OK, the chart will appear next to my data in the spreadsheet.

EDITING THE GRAPH

How To Make A Graph In Microsoft Excel | Sydney's Seminar | How To Make A Graph In Microsoft Excel | Sydney's Seminar | Sydney’s Seminar – How to Create a Graph In Microsoft Excel editing the graph

When you click on the graph, your ribbon automatically toggles to the Chart Design function. Here, you can change your graph’s colors, layout, and style if you want to customize it. You could also add an aspect to the chart by clicking “Add Chart Element.” One of these options is a personal favorite, the “Trendline” feature. This is an excellent way to normalize your data, especially if the data is over time.

The graph can be clicked and dragged wherever you want it in your Excel sheet, and you can copy and paste it into whichever document you would like it to show.

If you need to edit the data or add to it, no worries, the graph will change with your edits! To edit particular labels in the graph, you only need to click on the label.

I hope you found this How-To guide helpful. If you have any difficulties with Excel or would like additional training, give us a call at 301-456-6931 or email us at support@clarkcomputerservices.com

Have a great day!

5 1 vote
Rate This Post
Subscribe
Notify of
guest
0 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x