In my worksheet I have 2 columns of data. 600 data points in each column.
1. How do I set a line graph/chart up so that column A-cell 1 ($A$1) is the x-axis point and then the point plotted on the graph is column B-cell 1 ($B$1) and so on for all the cell entries in the 2 columns?
2. Once I have the above graph completed how do I import new data into those same cells and have the graph update to display the new data points?
1. How do I set a line graph/chart up so that column A-cell 1 ($A$1) is the x-axis point and then the point plotted on the graph is column B-cell 1 ($B$1) and so on for all the cell entries in the 2 columns?
2. Once I have the above graph completed how do I import new data into those same cells and have the graph update to display the new data points?