+ Reply to Thread
Results 1 to 2 of 2

Creating+saving multiple charts from a single worksheet

  1. #1
    Registered User
    Join Date
    10-17-2009
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    1

    Creating+saving multiple charts from a single worksheet

    Hi all,

    I would be grateful for any help you could provide with this query.

    Basically i have a lot of repetitive tasks to perform in work and need to speed them up so i can spend more time on interesting stuff.

    I am attempting to record a macro from a single work book that creates and saves multiple work books containing graphs of the data and the relevant data from the original workbook.

    I would also like to create hyper links for these graphs in another work book which contains all of the data graphed weekly.

    The data is spread through out the workbook so simple dragging will not work. I must do this for the start of every week. So for example i would generate data for drip rates for 50 seperate samples for week one then graph them and save them in a folder under week one then hyper link to them from another work book and then do the same the next week from data generated that week.

    I would truly love to automate this process.

    Thanks

  2. #2
    Forum Guru teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,364

    Re: Creating+saving multiple charts from a single worksheet

    Hi, what you're trying to achieve there is calling for some complex VBA (which I can't help with), but maybe you could have a look into interactive and dynamic charting instead of saving individual charts.

    With interactive charts, you provide the user with controls to select the data source and build the charts dynamically. You'll only need one chart per chart type and the user can select which week to look at.

    Look at http://peltiertech.com/Excel/Charts/Dynamics.html if you think this might work for you.

    hth

+ 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