Chart from CSV in Excel

In this lesson you will teach yourself how to create a chart from the csv file. It’s useful when you import csv file from other applications or the internet.

How to create Chart from csv?

Import the date from csv file to Excel.

data table

Go to the ribbon and click Insert. Choose type of graph which you want to insert.

On selecting graph a blank window will appear, on right click a drop down menu appears, from which choose Select Data option.

Select data

On clicking Select Data option a window will appear like this below. Click on Add option from left side.

add data source

A small window will appear. In Series name enter cell address and in Series values select the data row by row while holding Ctrl (this option allows multi-select). This step will plot the numbers in the order you selected.

edit series

Repeat the previous step for multiple series A2, A3… and in the result you get the graph window like this below.

chart from csv

Your chart is ready. That’s how to insert chart in Excel from csv (comma separated value) imported file.


You can download the Template here – Download
Previous articleAvoid Errors Using IFERROR-Everyone Should Know
Next articleLinking Text Box To A Specific Cell