+ Reply to Thread
Results 1 to 2 of 2

Graph every 24 rows automatically.

  1. #1
    Registered User
    Join Date
    10-20-2010
    Location
    Vancouver WA
    MS-Off Ver
    Excel 2007
    Posts
    1

    Graph every 24 rows automatically.

    I have 1 year worth of data, and the data is recorded every hour therefore I have 8760 entries worth of data. I want to graph this data by per day (every hour) but I don't want to do this 365 times. I know I can do this with VBA but I don't know how. basically, I want VBA to have a small for-loop so it can do this 365 times without me having to select the cells to be graph.
    data is arrange in 2 columns, the first one has the date and time and the second one has the data to be graph. and of course the first row contains the titles.
    I have been trying this for 2 days now and I can't figure this out any help will be appreciated.

  2. #2
    Valued Forum Contributor SDruley's Avatar
    Join Date
    04-27-2009
    Location
    Conover, NC
    MS-Off Ver
    Excel 2010 64 bit
    Posts
    415

    Smile Re: Graph every 24 rows automatically.

    Please send me the data or an example data sheet that does not compromise confidentiality
    Turn Data into Information
    Turn Information into Knowledge
    Turn Knowledge into Direction
    Turn Direction into Leadership
    Turn Leadership into Results
    Stephen Druley

    It's not how quickly you think
    But how deeply you think
    The quality of thinking is measured
    by remoteness to conformance
    Stephen Druley

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1