I don't know if this is even possible in any spreadsheet, much less Numbers, but...
I'm compiling a spreadsheet that displays a graph based on hourly performance from a table containing data from the past year. Each row contains a date. I'd like to have one pie chart that pulls data from records in this quarter, another for last quarter, and another for year to date. Is there a way that I can pull this based on values in another table?
That is, my criteria table may have
9/1/2007 and 12/31/2007 as beginning and ending values
The graph will pull data from the raw data table where my "date" is between 9/1/2007 and 12/31/2007.
Thanks,
I'm compiling a spreadsheet that displays a graph based on hourly performance from a table containing data from the past year. Each row contains a date. I'd like to have one pie chart that pulls data from records in this quarter, another for last quarter, and another for year to date. Is there a way that I can pull this based on values in another table?
That is, my criteria table may have
9/1/2007 and 12/31/2007 as beginning and ending values
The graph will pull data from the raw data table where my "date" is between 9/1/2007 and 12/31/2007.
Thanks,