A Numbers Chart from Multiple Sheets?
In Numbers '09, I'd like to make a chart on one sheet that draws data from multiple tables on multiple sheets. Is this possible? I tried for the longest time and finally gave up. Seems you can only draw data in a chart from multiple tables on the same sheet, not from different sheets. But is there something I'm missing? Anybody know?
The iPad version claims to do this exact same thing:
"You can even add data to a chart from multiple sheets in your spreadsheet with a few taps."
So, I thought, why not the Mac version? Am I going to have to wait for Numbers '11 or Numbers '12 or whatever the next version will be?