How to create graphs in Excel 2007?

Question

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:

1. 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).

2. 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).

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

Answer 1

It sounds like you want a PivotChart. You may wish to start with creating a PivotTable. And as has been mentioned in your comments, you'll probably want to save it as a xlsx to get all of the charting goodness.