Dynamic (?) chart


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
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top