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.
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.
On the clicking Select Data option, a window will appear like this below. On the left, select the "Add" option.
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.
Repeat the previous step for multiple series A2, A3… and in the result, you get a graph window like this below.
Your csv to chart conversion is complete. That's how to insert a chart from a comma-separated value imported file into Excel.