FutureStarr

Make a Graphor

Make a Graphor

Make a Graph

You know the drill: you have to write a report with a lot of data, but Excel can only handle a certain amount at a time. The answer is a chart. In this guide, we'll walk you through the steps to make a basic graph. From what I’ve seen of your work and others, there’s a risk of overselling, creating content that is too complex to digest. So what’s happening?

Data

Creating a graph with Visme’s graph maker is 100% free. Just sign up for a free account, choose a graph template or start from scratch using our powerful graph editor, which gives you full granular control over your graph settings, including data, colors, fonts, legends and more. If you want to use premium graph templates and features, you can upgrade to a Standard or Business plan.

Yes! It’s easy to add live data by connecting your graph to a Google Sheet. Simply head over to the Import Data tab in the graph editor, select Google Sheets and paste the URL of the Sheet you’d like to connect. Once you publish your project, your graph data will automatically sync with the changes you make in your Google Sheet. This means your published graph will be updated live on each visit so you no longer have to open and edit it manually. (Source: www.visme.co)

Use

To increase the size of your graph's labels, click on them individually and, instead of revealing a new Format window, click back into the Home tab in the top navigation bar of Excel. Then, use the font type and size dropdown fields to expand or shrink your chart's legend and axis labels to your liking. That was pretty easy, right? With this step-by-step tutorial, you’ll be able to quickly create charts and graphs that visualize the most complicated data. Try using this same tutorial with different graph types like a pie chart or line graph to see what format tells the story of your data best. You can even practice customizing more data-heavy graphs and charts using the free excel templates for marketers below.

Line and line with markers Shown with or without markers to indicate individual data values, line charts can show trends over time or evenly spaced categories, especially when you have many data points and the order in which they are presented is important. If there are many categories or the values are approximate, use a line chart without markers. 100% stacked line and 100% stacked line with markers Shown with or without markers to indicate individual data values, 100% stacked line charts can show the trend of the percentage each value contributes over time or evenly spaced categories. If there are many categories or the values are approximate, use a 100% stacked line chart without markers. (Source: support.microsoft.com)

 

Related Articles