up vote 0 down vote favorite
share [g+] share [fb]

I have data in the following format, where each label defines a row of data:

label1   x1 y1

label1   x2 y2

label1   x3 y3

label2   x1 y1

label2   x2 y2

label2   x3 y3

This is a very large data set, so selecting each range and adding it to the plot is out. Is there any way to plot it?

link|improve this question
Found something similar here: answers.google.com/answers/threadview/id/343380.html – Noel Dec 16 '11 at 1:29
Does each cell actually contain "x" and "y"? Or are there column headings? – CharlieRB Dec 16 '11 at 15:34
perhaps I should have used values instead. Each cell labeled x*, y* contains a numeric value – Noel Dec 16 '11 at 16:22
I'd recommend you consider removing the "x" or "y" in each cell and add headings. It will make it a lot easier to use the data the way you like. – CharlieRB Dec 16 '11 at 16:56
feedback

1 Answer

up vote 0 down vote

This known Excel Add-In has that functionality http://www.andrewsexceltips.net/JMT%20Full%20List.htm

It has a Ribbon so its esy to use in Excel 2007+

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

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