+ Reply to Thread
Results 1 to 3 of 3

Make the attached graph, Dynamic

  1. 09-09-2021, 08:46 PM #1
    mgs
    mgs is offline
    Registered User
    Join Date
    02-20-2011
    Location
    Queensland, Australia
    MS-Off Ver
    Office 365
    Posts
    71

    Make the attached graph, Dynamic

    Can anyone make the attached graph, Dynamic?

    Helper columns are welcome.

    I'm hoping to apply your logic, to more of my workbooks.

    mgs
    Attached Files Attached Files
    Last edited by mgs; 09-10-2021 at 02:02 AM.
    Reply With QuoteRegister To Reply
  2. 09-09-2021, 10:21 PM #2
    protonLeah
    protonLeah is offline
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,610

    Re: Make the attached graph, Dynamic

    Create a named range, thus:
    Data
    refers to:
    Please Login or Register  to view this content.
    Chart, select data, edit series, series values:
    ='Book1 (2).xlsx'!Data
    Attached Files Attached Files
    Ben Van Johnson
    Reply With QuoteRegister To Reply
  3. 09-10-2021, 02:01 AM #3
    mgs
    mgs is offline
    Registered User
    Join Date
    02-20-2011
    Location
    Queensland, Australia
    MS-Off Ver
    Office 365
    Posts
    71

    Re: Make the attached graph, Dynamic

    Thanks, protonLeah.

    It works a treat.

    Thanks,
    mgs
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Using A Formula To Make A Graph Dynamic
    By marathonrunner in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-30-2019, 12:02 AM
  2. how to make line graph dynamic based on date ranges?
    By mikey42979 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 05-09-2016, 03:33 PM
  3. How to make combine graph as attached figure in excel?
    By dzuhri1234 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 03-31-2015, 04:07 AM
  4. [SOLVED] How to make dynamic graph based on drop down
    By Aaron_Tram in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 06-02-2013, 02:35 AM
  5. Trying to make a dynamic chart to graph every OTHER row of data.
    By ssheldon in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 03-20-2013, 12:25 PM
  6. reproduce attached graph
    By MarsyasX in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 02-09-2008, 10:33 PM
  7. [SOLVED] graph using SERIEDynamic Range with unused formula messing up x axis on dynamic graph
    By cabybake in forum Excel General
    Replies: 6
    Last Post: 01-25-2006, 02:45 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1