I work with a team of industrial engineers and we send out daily a summary of the UPH's by department. I have a pivot table that pulls all of this information. I've made a chart of this data, but can't figure out a way to get the budgeted UPH data added in. Since our higher ups want to see this day by day and show historical data. Is there a way that I can pull from the pivot table and the raw data of the budget and put it into one chart.
Ideally, we would like to have the data auto update daily so I would like to keep the pivot table vs. creating a regular chart. I would like to streamline this process as mush as possible as we already do too much to get the data.
thanks in advance for any help
Ideally, we would like to have the data auto update daily so I would like to keep the pivot table vs. creating a regular chart. I would like to streamline this process as mush as possible as we already do too much to get the data.
thanks in advance for any help
