+ Reply to Thread
Results 1 to 2 of 2

Linking source data charts with macros applied

  1. #1
    Registered User
    Join Date
    04-18-2018
    Location
    UK
    MS-Off Ver
    2010
    Posts
    14

    Linking source data charts with macros applied

    hi folks,
    i have 2 files linked.
    1 file simply shows the same graphs as the other file (the source one)
    The source file has a macro which, when a section is closed on any given worksheet, the graph at the front does not show the data for that particular worksheet.

    so for example on the source file i've attached, there are 7 tabs with data on it, and 7 lines on the graph, but i have closed the row grouping on 4 of them, and so the graph only shows 3 remaining lines, for 3 worksheets of data which have the grouping expanded.

    i then copy and paste this file into a reporting file, and it shows the 3 lines only. However, if i close the Source file, the Reporting file shows all 7 lines of data.
    I do not want it to ignore the macro in the other workbook and to show all 7 lines, i want it to continue showing 3 lines as per the source file - so that whenever i update the source file, when i open the reporting file it will continue to show just the data that is showing in the source file.

    how do i do this? is it possible?

    thank you

  2. #2
    Registered User
    Join Date
    04-18-2018
    Location
    UK
    MS-Off Ver
    2010
    Posts
    14

    Re: Linking source data charts with macros applied

    anyone at all?

+ 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. Charts with variable data source
    By Geordie in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 07-22-2014, 12:55 PM
  2. Linking data from a common source
    By booo in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-09-2010, 08:08 PM
  3. Excel 2007 : Source Data in Charts
    By Janie in forum Excel General
    Replies: 1
    Last Post: 08-26-2009, 12:02 PM
  4. Charts and source data
    By jenster in forum Excel General
    Replies: 0
    Last Post: 08-31-2007, 08:58 AM
  5. creating charts using macros which picks up source data from the active sheet??
    By banana97 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-26-2007, 11:34 AM
  6. linking to external dbf data source
    By DSUM formula in forum Excel General
    Replies: 0
    Last Post: 07-05-2006, 04:00 PM
  7. [SOLVED] extending source data in several charts
    By Mike in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 11-29-2005, 01:40 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