Chart from csv


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.

1. Import the date from csv file to Excel.

data table

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

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

Select data

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

add data source

5. 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

6. 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 imported file.