I just started working on an application that takes data from several different information systems. It is basically a resource management application that forecasts planned hours and tracks actual hours. My co-worker uses Access to pull the data from the other information systems and aggregate it. Then he sends the data in Excel sheets to another co-worker who wrote some VBA macros to generate a chart that has stacked bars, lines and an area graph all in the same chart with a double X axis. Right now, they're producing ten different charts based on the data. Two of them are aggregates for the whole department but the other 8 are aggregates for each resource manager.
I have more experience with Access and VBA programming but I've done some stuff with Pivot Tables/Charts. I am envisioning creating some type of dashboard where the user can just filter all the aggregate data to generate the different views instead of having individual workbooks and running the macros to create a regular Excel chart/graph. I didn't even know it was possible to create a chart that has stacked bars, lines and an area graph all in the same chart with regular Excel charts. Can this be done with Pivot Tables? Also, would I be able to use MS Access VBA to create the workbook with the pivot charts?
I have more experience with Access and VBA programming but I've done some stuff with Pivot Tables/Charts. I am envisioning creating some type of dashboard where the user can just filter all the aggregate data to generate the different views instead of having individual workbooks and running the macros to create a regular Excel chart/graph. I didn't even know it was possible to create a chart that has stacked bars, lines and an area graph all in the same chart with regular Excel charts. Can this be done with Pivot Tables? Also, would I be able to use MS Access VBA to create the workbook with the pivot charts?