Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

share|improve this question
Your problem is that you're working in a CSV. Save the file as an Excel file and you're good to go. – user3463 Nov 8 '10 at 21:53

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.

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .