Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

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

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.