Graph Maker

How To Create Graphs in 2 Ways

In simple words, a graph is a diagram that is used to represent a large amount of data visually so that it can be easily understood by the end users and to facilitate comparison among those data sets if needed. If you have a look at practically any field of work, you will notice that they require making graphs in one way or other hence, you should always be able to answer the question of how to create a graph without hesitating. Making graphs isn’t a very complex task and tools like Visme can be very helpful if you haven’t made a graph by yourself.

There are a lot of online as well as offline tools that can help you to make some of the best graphs for your various business needs. It is important to choose the right tool when it comes to making graphs as they can provide you with some extra features and customizability options.

Part 1. 2 Ways How to Create Graphs

Method 1. Create Graphs with Excel

Excel is one of the most popular spreadsheet tools in the world and is found in nearly every single windows powered computer device. It allows you to make tables, spreadsheets and ofcourse, graphs. Excel allows you to create 9 different types of graphs according to your requirements. You can choose any option, enter the data and your graph will be ready in no time. Since excel is present in nearly every office, people know how to use it and even if you are new to it, making graphs with excel is very easy. It also allows you to add 3d effects and change colors of different values in your graph. If you ever search the internet about how do you make a graph using excel, you will surely come across the steps below

Step 1. Enter the data

The first step is to launch Microsoft excel on your desktop, now enter the data you want your graph to represent. Make sure that the data is from a trusted source and free of errors.

How To Create Graphs - Exccel - Step 1
Step 2. Choose the graph type

Now that you have entered the data, you will have to decide as to which graph type are you going for. Excel allows you to create line graphs, bar graphs, pie charts etc. In short you can create all the basic graph types in Excel.

How To Create Graphs - Exccel - Step 2
Step 3. Insert the graph

Once you have decided the graph type, highlight the data properly and go to insert option and click on the graph you want. Once you do that, you will have a chart rendered automatically for you.

How To Create Graphs - Exccel - Step 3
Step 4. Do basic tweaks for axis if needed

As the graph rendered for you is automatically generated, you can easily change any detail in the axis if you want. Make sure that everything is in its right place and perform necessary changes.

How To Create Graphs - Exccel - Step 4

The result should look like this:

How To Create Graphs - Exccel - Step 4-1
Step 5. Customize your graph’s visual aspects

Now your chart is nearly prepared to be saved but it is advised that you apply different colors and layout to make your chart easily understandable and to distinguish different data sets. Click on the edit button and apply the colors you want. It is better to choose completely different colors for different data sets.

How To Create Graphs - Exccel - Step 5
Step 6. Change the size of your chart's legend and axis labels

To make your chart a bit more readable and to enhance the understandability a bit further, you can tweak the size of the labels on your axis and the size of legends associated to various data. It isn’t necessary to do so but it can make your graph look better for the audience.

How To Create Graphs - Exccel - Step 6
Step 7. Do necessary changes

As of now, your chart will be complete and ready to be saved. But before saving it is better to analyze the graphs from audience perspective and doing the necessary changes. You can change the order in which data is present in your chart to make it easier to distinguish, change the measurement of both axis if you want and a lot more.

Step 8. Give it an appropriate title

Now give your graph a suitable title according to the quantities and the type of data it is representing. It is better if your title can explain the audience about the purpose it is made for.

Nearly everyone is aware of excel hence it gets a lot easier to avail help while making graphs with excel. It is a great tool for making graphs but the only let down is the lengthy process and the lack of customizability features like voice over, animation etc.

Method 2. Make Graphs with online graph maker

A lot of times, people do not have access to a computer, or it won’t be having the required tool to make graphs, in those scenarios the question pops up, how to make a graph online? Well, you can find tons of different tools on the internet that can help you to make graphs easily over the internet using the cloud servers. These tools are extremely powerful and can help you for free as well. One such powerful tool is Visme, as it allows you to create interesting and interactive graphs for all your business needs. This tool provides you with options to animate your graphs, apply voice overs and a lot more. Visme allows you to directly import data from excel sheets, Google docs, and other online sources which make it a lot better than other online tools. It has tons of templates for creating specialized graphs that can be used for variety of purposes.

Part 2. How to Create Line Graphs with Visme

Visme Graph Maker
  • Create animated charts & graphs in minutes.
  • Use a template or create from scratch.
  • Over 20 types of graphs and hundreds of templates.
  • Integration with live data.

The following are the steps that you will have to follow in order to create a perfect graph using Visme:

Step 1. Log in to Visme

The first step is to search for Visme on your web browser and then to log in. If you haven’t registered before, enter your details and sign-up to make your graph. Once you are done logging in, you will be taken to your dashboard where you will notice a ‘Create +’ option on the left hand side of the screen. You have to click on it and select the type of chart that you want from Visme’s large support library.

How To Create Graphs - Exccel - Step 1
Step 2. Enter the data

Now that you have selected the type of chart you want to make, it is time to enter the data into the graph. You can enter the data manually from the right hand side box, which will have columns for X and Y axis separately. Visme also allows you to import the data directly from an Excel sheet into your graph. You can also use Google docs to fill in the data or even from a different online source. Just make sure that the data is from a credible source and is easily readable. You can also change various aspects according to your requirements including colors, size of the axis and also the style and fonts. Try to keep your graph as simple and clear as you can.

How To Create Graphs - Exccel - Step 2
Step 3. Save and Share

If you have successfully completed the above steps, then your graph will be ready to be inserted into your project by now. If you opted for an interactive graph, Visme will automatically animate various aspects of your graph to give it a certain interactive look, you can customize it as well. Now you can directly email it to your friend or superiors, save it in your hard drive, save as an image to print it, and even save it over their cloud servers. It can also be saved as a PDF file or an animated HTML5 file to facilitate their usage on websites.

How To Create Graphs - Exccel - Step 3


Every field requires making chart in one way or another. Teachers use graphs to make sure that6 their students can easily understand large sets of data, businesses use it to track a trend, compare performance or even analyzing market opportunities. Everyone should have knowledge about how to make a graph with the various online and offline tools that are widely available on the market. If you are looking for an easy to use yet powerful online tool, Visme will be the best choice for you. Visme is an easy to use tool used by a lot of beginners as well as experts due to the variety of powerful features it provides to the users. This tool offers the users to create stunning graphs by providing them with options to animate it, add images, link it to websites, and add 3d/4d modeling and a lot more. You can use this tool for free due to its free trials. If you plan on learning more about the features and pricing of Visme, you can visit their official website.

Oct 15,2019 17:31 pm