I have a data set with 6 unique X and Y variables for each series and ~500 series to plot (will not show 500 at once but need to be able to show filtered groups). I cant seem to get Excel 2007 to understand unless I enter them one series at a time.
See attached sheet for what I want the output to look like. I just dont want to spend a week entering each series one at a time.
dummy.xls
Hello gregoir,
repetitive tasks like this can take a week to do manually, or you can use a macro. In this particular instance, create the first two data series manually, then run the following macro to add the other data series automatically. It will create as many data series as are listed in row 5 and below.
You can change the parameters of the macro to suit your workbook.
The code needs to go into a standard module. (If that last sentence means nothing to you, please pipe up and someone will help you to install it in the right place).
Please Login or Register to view this content.
cheers,
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks