Pivot Table\Chart

Jdubb

New member
Joined
Mar 20, 2019
Messages
1
Reaction score
0
Points
0
Excel Version(s)
365
Problem,

I have information I put into a pivot table. The pivot is "Filtered" by Line.
I want to be able to create combo graph for each line. "Line data" for the capacity in each month" "Stacked column" for the items being manufactured in each month.
How can I use the pivot data in a way that when I select each line I can see the information of 7 and 5 day capacity + current demand for the month and maintain format and structure of the pivot chart. It refreshes and loses its formatting.

How can I use the pivot data in a dynamic way so that when I filter the chart for a particular line (dashboard purpose) the graph changes and retains formatting of stacked verses line chart type. Is this possible?

Thank you for the help.

Best
J
 

Attachments

  • pivot chart by line.xlsx
    28.8 KB · Views: 20
  • line data.jpg
    line data.jpg
    91.2 KB · Views: 19
Back
Top