I have a multi-type blood test table, and I need 2 values: test dates and test results for a bar chart of every test. I am using a formula If(Name column = "Test name", Test result), and copy drag this down to the whole table, then delete the cell that doesn’t filter out what I want, which say "false" value. Is there a better way? I can’t remember the Access and My SQL stuff and don’t have My SQL software either.
July 29th, 2010 on 12:31 am
just my opinion, but i would do it the exact same way that you are.
if this is in excel, then you can make a pivot table, and make a pivot chart out of the table…that will eliminate the drag&filter step. you just have checkmarks.