Let’s say we’re visualizing marketing ROI.

[hoxesi8100@]

Let me walk you through my steps.

1. Enter your data into Excel.
So, I start by plugging in my data, which I organize into columns and rows. This is basic, but it's all you need to start.

Whether you’re importing data from a survey tool, downloading it from your marketing platform, or simply typing it in manually, step one is organize.

Let me show you a quick example of how I organize my data.


organize data in excel

As you can see in the spreadsheet above, I’ve organized it as follows:

Column A lists responses to the question, “Did inbound armenia phone number material marketing demonstrate ROI?” or “Could not or did not calculate ROI?”
Columns B and C list responses detailing whether or not the company had a formal sales-marketing agreement.
So, as per my data arrangement, Column B, Row 2 illustrates that 49% of people with a service level agreement (SLA) also say that inbound marketing demonstrated ROI.

2. Choose your graph or chart type.
Once my data is in and organized, I choose my preferred graph style. Excel offers many options, including bar charts, line graphs, pie charts, scatter plots, and more.