H
Hooligan
I have a variety of data lists (production levels, sales, labour costs
that are calculated and combined into a summary table for my productio
mgmt to review. The lookups etc. are based on a date range entered o
this table; they enter the start and end dates into different cell
which returns totals for the categories to the table.
I would like to graph results per day defined by the date range tha
they are looking at. The source for the graph is another table tha
collects all the info from the data tables and totals them per day.
need the graph to select data from that list starting at the date use
to collect data for the table until the end date selected.
I have considered LOOKUP and INDIRECT and MATCH type functions but can'
fathom how to have a chart be dynamic with differeing start and en
points.
Is this even possible
that are calculated and combined into a summary table for my productio
mgmt to review. The lookups etc. are based on a date range entered o
this table; they enter the start and end dates into different cell
which returns totals for the categories to the table.
I would like to graph results per day defined by the date range tha
they are looking at. The source for the graph is another table tha
collects all the info from the data tables and totals them per day.
need the graph to select data from that list starting at the date use
to collect data for the table until the end date selected.
I have considered LOOKUP and INDIRECT and MATCH type functions but can'
fathom how to have a chart be dynamic with differeing start and en
points.
Is this even possible