In Excel, your options for charts and graphs include column (or bar) graphs, line graphs, pie graphs, scatter plots, and more. In the example below, in Column A, I have a list of responses to the question, “Did inbound marketing demonstrate ROI?”, and in Columns B, C, and D, I have the responses to the question, “Does your company have a formal sales-marketing agreement?” For example, Column C, Row 2 illustrates that 49% of people with a service level agreement (SLA) also say that inbound marketing demonstrated ROI.Ģ.
You might have exported the data from elsewhere, like a piece of marketing software or a survey tool.
The steps you need to build a chart or graph in Excel are simple, and here’s a quick walkthrough on how to make them. Surface charts plot sets of values in the form of a three-dimensional surface. Stock charts are used to report the fluctuation of stock prices over given periods. Scatter charts show the positive or negative relationship between two variables. Radar charts compare the aggregate of multiple data series. Pie charts show values as percentages of a whole. Similar to bar charts, they illustrate trends over time. You can make more than just bar or line charts in Microsoft Excel, and when you understand the uses for each, you can draw more insightful information for your or your team’s projects.Īrea charts demonstrate the magnitude of a trend between two or more values over a given period.īar charts compare the frequency of values across different levels or variables.Ĭolumn charts display data changes or a period of time. But before diving in, we should go over the different types of charts you can create in the software.
I thought I'd share a helpful video tutorial as well as some step-by-step instructions for anyone out there who cringes at the thought of organizing a spreadsheet full of data into a chart that actually, you know, means something. However, it's no surprise that some people get a little intimidated by the prospect of poking around in Microsoft Excel.
Next, we will show you how to build an Excel chart with a manual data selection.Building charts and graphs are one of the best ways to visualize data in a clear and comprehensible way. We have seen how to create a graph with auto-selection of the data range. Now, we have a neatly arranged chart in front of us.