Loading
Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports



Results 1 to 9 of 9

Thread: Run Chart as Animate by start and stop button

  1. #1
    Join Date
    22nd December 2016
    Posts
    28

    Run Chart as Animate by start and stop button

    i need your help to solve my problems. i have a workbook which contains three worksheet name called ( Alpha, Bravo,Charlie) and each worksheet there is a chart and i display all the chart in one worksheet called All in one sheet. Now what i need i need to run the chart as animate of whole year data value or selecting by months wise. if i click button start and stop the chart should run as Animate of whole year.


    i attached my file for our reference and video look here https://www.youtube.com/watch?v=3Fn9LiE8UKo


    sample file i am attaching please help me it will be great appreciate to me .

    i have to animate in worksheet name called ( All chart in one)
    2. sample file i attached same like i need to run the chart please...... help me.
    Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros. Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    22nd December 2016
    Posts
    28

    Re: Run Chart as Animate by start and stop button

    please anyone help me ?

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    9th April 2007
    Location
    Alstonville, Straya
    Posts
    5,724

    Re: Run Chart as Animate by start and stop button

    Hi sathishsusa,
    Have you download the example in the youtube clip?

  4. #4
    Join Date
    22nd December 2016
    Posts
    28

    Re: Run Chart as Animate by start and stop button

    Hi Pike ,

    Thanks a lot i got the reply and waiting for the long time yes i download the file pls see the attachment.

    pike if difficulties to do same thing its not a matter. i need to run the graph as animate to whole year and add your idea and design on my chart are make to best appearance that i want it. please pike ...
    Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros. Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.

    Excel Video Tutorials / Excel Dashboards Reports


  5. #5
    Join Date
    9th April 2007
    Location
    Alstonville, Straya
    Posts
    5,724

    Re: Run Chart as Animate by start and stop button

    Hi
    Can you just transfer your data to download file or add it to your workbook?
    Then add a combobox to change the data set?

  6. #6
    Join Date
    22nd December 2016
    Posts
    28

    Re: Run Chart as Animate by start and stop button

    pike i tried that one but its nothing to link with the data to chart. if possible there is some sample file i attached somewhat its working fine but exactly what i need is shown in the worksheet called (Example of chart) can you have look on it.
    i need to link the data with the scroll bar to run with the timer of months to view the visible data graph because in all chart in 1 sheet having a short gap between the months.
    Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros. Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.

    Excel Video Tutorials / Excel Dashboards Reports


  7. #7
    Join Date
    9th April 2007
    Location
    Alstonville, Straya
    Posts
    5,724

    Re: Run Chart as Animate by start and stop button

    Hello
    you can change this bit
    VB:
    For c = MinValue To Cells(Rows.Count, 2).End(xlUp).Row - Range("Interval") Step Range("Step") 
         'For c = MinValue To 1201 - Range("Interval") Step Range("Step")
        Range("Start") = c 
        DoEvents 
    
    
    Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros. Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.

  8. #8
    Join Date
    22nd December 2016
    Posts
    28

    Re: Run Chart as Animate by start and stop button

    Hi Pike,
    sorry for late reply very nice you did it. if possible i need some changes on this chart i need the data which i want to show in chart is column: B (date), H(Corrected DP reading) , K(Target of filter value). How can i modify to range to display on chart.

    Excel Video Tutorials / Excel Dashboards Reports


  9. #9
    Join Date
    9th April 2007
    Location
    Alstonville, Straya
    Posts
    5,724

    Re: Run Chart as Animate by start and stop button

    sure replace the chart module code with
    VB:
    Private Sub Worksheet_Change(ByVal Target As Range) 
        Dim objCht As ChartObject 
        If Not Application.Intersect(Range("G4"), Target) Is Nothing Then 
            Select Case True 
            Case Target.Value = "alpha chart" 
                Sheets("chart").Range("A2:A364").Value = Sheets("ALPHA").Range("B20:D384").Value 
                Sheets("chart").Range("B2:B364").Value = Sheets("ALPHA").Range("H20:H384").Value 
                Sheets("chart").Range("C2:C364").Value = Sheets("ALPHA").Range("K20:K384").Value 
            Case Target.Value = "Bravo chart" 
                Sheets("chart").Range("A2:A364").Value = Sheets("BRAVO").Range("B20:D384").Value 
                Sheets("chart").Range("B2:B364").Value = Sheets("BRAVO").Range("H20:H384").Value 
                Sheets("chart").Range("C2:C364").Value = Sheets("BRAVO").Range("K20:K384").Value 
            Case Target.Value Like "charlie chart" 
                Sheets("chart").Range("A2:A364").Value = Sheets("CHARLIE").Range("B20:D384").Value 
                Sheets("chart").Range("B2:B364").Value = Sheets("CHARLIE").Range("H20:H384").Value 
                Sheets("chart").Range("C2:C364").Value = Sheets("CHARLIE").Range("K20:K384").Value 
            Case Else 
            End Select 
        End If 
        For Each objCht In ActiveSheet.ChartObjects 
            With objCht.Chart.Axes(xlValue) 
                .MaximumScale = Application.WorksheetFunction.Max(Range("B20:B384").Value, Range("C20:C384").Value, 0) + 10 
                .MinimumScale = Application.WorksheetFunction.Min(Range("B20:B384").Value, Range("C20:C384").Value, 0) 
                .Crosses = xlCustom 
                .CrossesAt = Application.WorksheetFunction.Min(Range("B20:B384").Value, Range("C20:C384").Value, 0) 
            End With 
        Next objCht 
    End Sub 
    
    

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Start and Stop Macros
    By biocentrism in forum Excel General
    Replies: 9
    Last Post: October 1st, 2014, 06:20
  2. Determine Start Stop Time No VBA
    By Agent18354 in forum Excel General
    Replies: 3
    Last Post: July 18th, 2012, 11:04
  3. Changing Calendar Start And Stop Dates
    By rmoreno in forum Excel General
    Replies: 11
    Last Post: June 27th, 2007, 22:00
  4. Animate chart
    By El_Pi-L in forum Excel General
    Replies: 2
    Last Post: December 7th, 2005, 01:22
  5. help on start / stop problem
    By stevehorton09 in forum Excel General
    Replies: 9
    Last Post: February 2nd, 2005, 02:39

Bookmarks

Posting Permissions

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