On 11/15/2010 4:53 PM, Alan Evans wrote:
I have a set of data (from bonnie++) that represents different test cases
each with 3 samples. I would like to chart the data but average the
samples.
Subtotals and Data Pilot give me nearly what I want but not quite.
Ideally I would like to be able to paste data in one sheet and have charts
generated from the averaged samples on another sheet.
My data looks something like:
name,size,putc,putc_cpu
foo-sda-test1, 16G, 36000, 90
foo-sda-test1, 16G, 36001, 89
foo-sda-test1, 16G, 36002, 88
foo-sda-test2, 16G, 38000, 80
foo-sda-test2, 16G, 38001, 79
foo-sda-test2, 16G, 38002, 78
And I want to chart:
foo-sda-test1, 16G, 36001, 89
foo-sda-test2, 16G, 38001, 79
Where the 2 rows above are the averages of the 2 sets of 3 rows above that.
I could do a macro but there has to be a way to do this more elegantly. Any
thoughts?
Regards,
-Alan
Charts may be cut and pasted. Create your chart - it will naturally
fall on the same worksheet. Then cut it, change to a new worksheet, and
paste it. Then, you can size it, and rename the worksheet tabs if you wish.
Joe Conner, Poulsbo, WA USA
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org