Multiple Charts from Pivot Table

  • Re: Multiple Charts from Pivot Table


    Hi Luke, I do get a general average, the average doesnt change throughout changing charts.


    Does this need to be changed:


    Code
    Private Sub Worksheet_Change(ByVal Target As Range)
    'Check if user changed component
    If Intersect(Target, Me.Range("D1")) Is Nothing Then Exit Sub
    
    
    
    
    Call ResizeAxis
    End Sub
  • Re: Multiple Charts from Pivot Table


    Was it working in the example file I just uploaded?


    In the real file, you'll need to change the cell reference to be whichever cell the Country is displayed in. In the example file, that cell was B1.

    Best Regards,
    Luke M
    =======
    "A little knowledge is a dangerous thing."

  • Re: Multiple Charts from Pivot Table


    Not working for me, it stays at 0 to 24 hours and works nice for some, the others not so much, so maybe ill try a different min or max like you suggested.. and seem to have it configured exactly how you have it. Yours works perfect.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!