+ Reply to Thread
Results 1 to 1 of 1

Link multiple, identical graphs to multiple data tables

  1. #1
    Registered User
    Join Date
    12-29-2012
    Location
    Sheffield
    MS-Off Ver
    Excel 2010
    Posts
    7

    Link multiple, identical graphs to multiple data tables

    Hi,

    I've created a huge amount off data that needs to be crunched and graphed.
    The data tables all show the same thing, valve angle vs pressure drop, but for different conditions.
    I've attached a sample table showing one table, with an example graph next to it. For each of these tables I'm going to make 3 or 4 graphs in a row. However, i have about 30 of these tables in a column and don't like the idea of having to copy and paste the original graphs, then open up each graph to alter the links to the newest table.

    Is there anyway to copy and paste graphs to many sets of data?

    If this can't be done, what would be a better option. I haven't had any experience with VBA or macros, however i'm open minded to learn and use them if required.

    Sample book.xlsx

    Please post a link to anything if this has been answered before or any other useful links.

    Thanks,
    HJII
    Last edited by HJII; 03-06-2014 at 06:35 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Generalizing identical multiple rows of data into one row...?
    By Cheekychives in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 01-18-2013, 10:45 AM
  2. VBA Pivot Table - Multiple Tables - Multiple Sources of Data
    By ryanmorris in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-08-2012, 03:13 PM
  3. Multiple Data Tables Link and Calculate onto Target Tables
    By billexchry in forum Excel General
    Replies: 6
    Last Post: 03-04-2011, 02:42 PM
  4. Data from multiple identical sheets
    By clacka in forum Excel General
    Replies: 3
    Last Post: 01-07-2011, 10:40 AM
  5. Replies: 2
    Last Post: 05-27-2010, 11:39 AM

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