+ Reply to Thread
Results 1 to 3 of 3

Copy chart with same data ranges for different spreadsheets?

  1. #1
    Registered User
    Join Date
    12-03-2014
    Location
    Arkansas, United States
    MS-Off Ver
    2010
    Posts
    4

    Copy chart with same data ranges for different spreadsheets?

    So I have like 10 spreadsheets that are all set up the same way but with different data (basketball statistics for different players). I'm going to want 3 or 4 charts on every spreadsheet for each player. Now I don't want to have to manually create 30 different charts... Can I make a chart on the first spreadsheet and copy it over somehow so that it updates the data ranges for the same ranges but on spreadsheet 2?

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,609

    Re: Copy chart with same data ranges for different spreadsheets?

    My favourite way:
    start registering macro before you start creation of graph in one workbook
    at the end stop registering
    open second workbook (dont close first one) and go the same sheet
    run this macro. On macros list (Alt F8) its name (usually Macro1) wil be preceeded by original workbook name.
    Best Regards,

    Kaper

  3. #3
    Registered User
    Join Date
    12-03-2014
    Location
    Arkansas, United States
    MS-Off Ver
    2010
    Posts
    4

    Re: Copy chart with same data ranges for different spreadsheets?

    Thank you! I'm new to the advanced Excel features, didn't know you could record macros in Excel.

+ 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. Copy and paste based on found cells using two spreadsheets with dynamic ranges
    By shawnsonline in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-28-2012, 02:49 PM
  2. Copy data between 2 excell spreadsheets
    By omer123456 in forum Excel General
    Replies: 2
    Last Post: 11-29-2011, 08:18 PM
  3. Chart Data to fill in spreadsheets
    By dagindi in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-04-2011, 07:33 AM
  4. Lookup and copy data between two spreadsheets
    By jgombola in forum Excel General
    Replies: 0
    Last Post: 01-24-2008, 08:45 PM
  5. Copy data in named ranges to a newer version of the same template to identical ranges
    By handstand in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-21-2006, 10:51 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