Results 1 to 1 of 1

Help with chart

Threaded View

GDM69 Help with chart 03-15-2013, 11:21 AM
  1. #1
    Registered User
    Join Date
    04-27-2012
    Location
    india
    MS-Off Ver
    Excel 2003
    Posts
    45

    Help with chart

    I am looking for a macro to draw a chart for part of the data based on a certain value. I am enclosing a sample file for better understanding. I want the macro to look at a certain value, namely 15:15:00, in column C and then plot a chart from that particular row to the last row with values in column C on x (horizontal) axis and values in column G on Y (vertical) axis. The chart should appear preferably at .left 350, .top 500 position. In the present file, the value 15:15:00 appear at row no. 361 and the last row no is 379, so the chart range should cover rows 361 to 379. I wish to draw the charts in all the files in a folder. All files have only one sheet and I use Excel 2000. I would appreciate any help in this matter.
    Attached Files Attached Files

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