Here is an easy to follow tutorial that will help you to learn how to make a chart in Excel. You will start with simple and then work your way up to more advanced charts and graphs. This article has been designed for those who are familiar with Excel and want to learn how charting is done. It assumes that you already know how to create a spreadsheet and enter data into cells etc.
In this article, we shall be looking at tools to help us and also the process of creating charts in excel.
LiveGap
LiveGap is a free charting tool that allows you to create free charts online without installing any software on your system. This website supports making line, bar, area, pie, polar area, doughnut, radar, step and step bar charts. This is also a free charting tool so you can create your own personalized charts without spending anything. While making charts and graphs using this online charting tool you can preview the chart or graphs with the customization options.
Meta Chart
Meta chart website is also a very powerful and good website which helps you to create the charts for free without paying anything. Meta chart website allows users to quickly create charts online using the premade templates or your own chart from scratch. This is a free website but you need to register there to access all feature of the website. This website is able to create pie, chart, line, venn, histogram, Tally, Box and whisker charts for free of cost.
Chart Blocks
Chart Blocks is a chart building tool to create free charts. This online chart building tool allows users to create free charts online for free without doing any coding. You don’t need to be a technical person to use this website because everything is crystal clear and you can directly use the website. Thousands of people have used this website to create their charts and rely on it. The website offers free service for a limited time and later you have to buy premium version to continue making your charts.
Draw
Draw is a very simple to create chart tools excel diagrams. Draw website have hundreds of shapes in it which can be used while making the graphs and charts. While using this website you can save the graphs directly to your Google drive of DropBox account as well. This website works just like software and gives you feed that you are using a desktop program. It fully support drag & drop for dragging and dropping the elements in the functional area from the website interface.
Rapid Tables
Using Rapid Tables, you can create line graphs with a maximum of six lines. It will allow you to save the graph as a PNG image. The website also provides with the print option for the created graph.
Features:
- You can name the horizontal and vertical axis.
- On the horizontal axis, it will allow you to add data labels, data values, or data range.
- It will allow you to add 6 lines.
- A curved line can also be added.
Price: Free
Website: Rapid Tables
NCES Kids Zone
NCES provides an online tool to create the line graph.
It is useful for creating simple as well as complex graphs. You can select the size of the graph as small, medium, large and extra-large. The created graph can be exported as a PNG or JPEG image.
Features:
- It will allow you to select the point shape and color.
- You can select the size of the point shape.
- You can add a title to the Graph, X-axis, and Y-axis.
- It will also allow you to select the line color.
- You can add up to 15 values on the X-axis and Y-axis.
Price: Free.
Website: NCES Kids Zone
Meta-chart
Meta-chart will allow you to create the Line chart for free.
By just entering the design specifications, data, and labels, you will get the chart in the Display tab. You can create a free account so that your graphs will be saved and can be edited anytime. Created graphs can be exported in SVG, JPEG, PNG, and PDF formats.
The tool will also allow you to share the created graphs.
Features:
- You can select a background color and a border color if required.
- It will allow you to select the Legend position.
- It will allow you to select the color and font size for the tooltip.
Price: Free
Website: Meta-chart
Visme
Visme is the tool for creating Presentations, Infographics, Charts, and Reports.
You can create animated charts and graphs using this tool. It will allow you to create graphs by importing your data in XLSX and CSV format or by uploading the live data from Google Sheets.
Features:
- Hundreds of templates are provided.
- More than 20 types of charts can be created.
- Integration with Google Sheets.
- You can share, embed, and download the created graphs.
Price: Visme provides three plans i.e. for individuals, businesses, and education.
- Plans for Individuals – Basic (Free), Standard ($14 per month), and Complete ($25 per month).
- Plans for Businesses – Complete ($25 per month), Team ($75 per month), and Enterprise (Contact the company).
- Plans for Education – Student ($30 per semester), Educator ($60 per semester) and School (Contact the Company).
Website: Visme
Online Chart Tool
Online chart tool will allow you to create different types of graphs.
For Line graphs, you can create the graph out of three types i.e. Line, Spline, and Step. The tool provides a good number of options to download the chart. It will also allow you to share it through email.
Features:
- To design the line graph, this tool provides many styles and appearance factors.
- While adding data, the tool will allow you to add up to 10 groups (Lines) and 100 items.
- You can download the graph as an image, CSV, PDF, SVG, and in high resolution.
- The tool will allow you to save the graph so that you will be able to edit it later.
- You can share the graph through email.
Price: Free
Website: Online Chart Tool
ChartGo
ChartGo is a free tool for creating graphs online.
It is useful for creating finance and stock charts. Many chart settings are available with ChartGo like 3D lines, thick lines, curved lines, transparent, shadow etc. It is useful for teachers and students as well.
Features:
- It will allow you to upload data from Excel and CSV files.
- It allows you to create a line graph with curved lines or trend lines.
- You can download the created graph as an image, PDF, or SVG.
- You can preview the printable version of the graph.
Price: Free
Website: ChartGo
Canva
Canva, as the name of website implies that this website is mainly developed to create beautiful charts for your work. There is wide range of premade templates available on website which can be used for free while creating charts. You just need to enter the data and the website will create the needed chart for you without any cost. The website also comes with the feature of switching between different types of charts such as line graphs, bar graphs etc with the same data and without losing the original data.
Vizzlo
Vizzlo is another browser based online chart tool which helps you to create mostly all kinds of charts. There are near about 100 templates offered on the websites for the several different types of businesses. With the help of this website you can create timelines, process diagrams, Gantt Charts and so many other types of charts. These all charts are offered for free but there a company watermark logo will be there. To remove this logo you need to buy premium plan of the Vizzlo.
how to make Charts with Visme
This is really very easy to create charts using Visme website you just need to browser and sign up on the website and then you can create unlimited charts without worrying about the limitations. Let’s see how to create charts using the Visme Website.
Step 1
Firstly, please visit the below URL and then click the “Get Started” button (If you don’t have any account on the website) otherwise click the “Login” button and login to your account using your credentials.
Step 2
Once you are logged in then you will be at the main interface of the website which will looks like the below screenshot. Now look at the top left side and hit “Create” button to start a new project.
Step 3
After hitting the “Create” button you will be diverted to the next screen. Here you need to select what type of file you want to create. We have selected infographics here and we are choosing one template from the hundreds of templates.
Step 4
Now you need to select the right option. Look at the left side tab of website. Here you can select several things such as basics, graphics, media, data and theme colors. If you want to select any type of file or data from external source then you can also import them using my file tab. Once you have edited and prepared your chart then look at the top right side. From there you can preview, share or download the charts on your computer. That’s it.
Conclusion
Graphs and charts can be created in many different ways and Excel offers a lot of options. With the right combination of figures, ranges and formulas you can create just about any type of graph imaginable. Creating graphs and charts could be as simple as making a line graph or pie chart by using data you already have. The trick is knowing how to enter the data into the cells and then learn how to format it once it is there.