I have a PivotChart that graphs performance by month for each doctor. For example, DOCTOR A has a stacked bar for February, March, and for April. DOCTOR B has the same months and is right next to DOCTOR A and so on.
The pivot table summarizes performance by month AND gives a cumulative rate (subtotal). How can I graph that cumulative subtotal by doctor. I can currently graph each month, but not the subtotal. Is this even possible?
The pivot table summarizes performance by month AND gives a cumulative rate (subtotal). How can I graph that cumulative subtotal by doctor. I can currently graph each month, but not the subtotal. Is this even possible?
