Results 1 to 1 of 1

Help wth arranging/graphing data macro

Threaded View

  1. #1
    Registered User
    Join Date
    02-06-2005
    MS-Off Ver
    Excell 2016
    Posts
    35

    Help wth arranging/graphing data macro

    Hi,
    I have been able to create a marco to organise large quantities my scientific data with the grateful assistance of much more able programmers than I.

    I need to make the macro a bit more like a template and also make it more flexible to use. Certain parameters change over time (i.e the no of data points Columns Title A, B,C,D,E etc)


    The time column is a variable and requires the use of the formula (e.g. =D2+D$2). But I want the forumla to automatically fill down till the end of the data.

    I would like the marco when it rearranges the data to automatically highlight all the rearranged data (Columns E2 to M2) until it reaches a blank cell and stop. I would then like the time column (Column D) to fill down until it reaches the end of data rather than manually filling in the cell range in the macro.

    After the data is fully arranged I would to automatically highlight the entire data set and draw a x-y graph. At the moment my macro only highlights my selected cell range and then makes the graph. y dataset ranges will change alot

    I am including a excel file of what I am trying to achieve.
    Thanks,
    Frank
    Attached Files Attached Files

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