Results 1 to 2 of 2

Thread: Pivot Table\Chart

  1. #1
    Neophyte Jdubb's Avatar
    Join Date
    Mar 2019
    Posts
    1
    Articles
    0
    Excel Version
    365

    Pivot Table\Chart



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

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

  2. #2
    Acolyte bobjglover@gmail.com's Avatar
    Join Date
    Aug 2015
    Posts
    26
    Articles
    0
    Excel Version
    1901
    Have you considered a simple combo box, not sure if the function will meet your needs but take a look at this link for my example. Good luck.

    https://www.youtube.com/watch?v=tZumAMCxFl8

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
  •