Results 1 to 2 of 2

Thread: Pivot Table\Chart

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Neophyte Jdubb's Avatar
    Join Date
    Mar 2019
    Excel Version

    Pivot Table\Chart


    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.

    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	line data.jpg 
Views:	17 
Size:	91.2 KB 
ID:	8982  
    Attached Files Attached Files

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts