Hello, I'm having a lot of trouble doing something that I figure is actually pretty simple to do -- I hope folks can help me out!
I have a simple dataset (this is from my duaghter's homework assignment actually!) which I've uploaded to a google doc just so you can see what it looks like: https://docs.google.com/spreadsheet/ccc?key=0Aqhzp2yOOf0zdGc1MHozTm1XblZTdWVLN2JkcE4ySUE I want to be able to make one simple scatter plot of one column ("Time of Day") against another column ("Response Time in Minutes"). But I want to use the value of a third column ("Company") to FILTER the results, and graph the filtered results against each other. So, in this case, we have two companies, "Metro" and "Arrow". I want my graph to display the Arrow Datapoints in (say) Blue, and the Metro datapoints in (say) red. I feel like this ought to be easy to do, by defining a filter condition in the data range. This doesn't seem possible though. And if I try to do it through the graphical interface, using filters, say, then I can only ever graph one filter condition at a time. The only workaround I've found is to sort the data by company name, then define the data ranges of 2 data series based on that. But if I happen to resort my data, or add new rows, then the chart won't update dynamically in an appropriate way. Is there a good way to do what I'm trying to do? Thank you for your help! Matt -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted