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