+ Reply to Thread
Results 1 to 1 of 1

Iterative Charting

  1. #1
    Registered User
    Join Date
    04-12-2011
    Location
    Seattle, WA USA
    MS-Off Ver
    Excel 2007
    Posts
    18

    Iterative Charting

    Is it possible to create a macro or VB Script that will do the following.
    Once data is imported into the spreadsheet and parsed correctly, a chart needs to be generated and labelled correctly. This is a routine task that happens every Wednesday as new data from log files is automatically pulled in.

    For example I have data from testing for week one and it is manually entered into a chart, I do the same for weeks 2 and 3 respectively. However, since the testing is the same and the only thing that really changes is the number of hours a test is run.

    I would like to setup up a method for the data to be pulled into a chart automatically and added to the previous weeks testing data in the chart

    I have included the file here for example

    thanks
    Shaun
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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