I have data in CSV format, and I want to create a few graphs. I was looking around in google for how to do that, but it seems like most help about Excel graphs does not match my version of Excel (2007).
The CSV is split into columns. Some columns are symbols, some columns are numbers. I want to:
Take a column of a symbol and two columns of number, and create a scatter plot where in the x-y we have the numbers and the color of the dot is according to the symbol (a color allocated per symbol).
I want to be able to filter from the scatter plot all data where a certain, another column, does not equal a certain number (i.e. if the data is columns A,B,C,D and the symbol is in A and the xy plot includes B,C, I want to filter out all data points such that D is not 0.05).
I want to create an xy plot (a line) with two columns, where all points from the same symbol are aggregated to create a single line. Each symbol will have its own line.