How to Create Graph from Csv File

In this Excel charting lesson, you will learn how to create a chart from a csv file. It's useful when you import csv files from other applications or the internet.

How to create a chart from csv?

Import the date from the csv file into Excel.

csv chart data table

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

On selecting a graph, a blank window will appear. On right clicking, a drop-down menu appears, from which you can choose the Select Data option.

csv chart Select data

On the clicking Select Data option, a window will appear like this below. On the left, select the "Add" option.

csv chart add data source

Visualization of CSV data

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

csv chart edit series

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

chart from csv

Your csv to chart conversion is complete. That's how to insert a chart from a comma-separated value imported file into Excel.