+ Reply to Thread
Results 1 to 5 of 5

Dynamic Line Chart For Variable Table

  1. #1
    Forum Contributor
    Join Date
    04-16-2020
    Location
    Tehran, Iran
    MS-Off Ver
    2019 v2306
    Posts
    145

    Dynamic Line Chart For Variable Table

    Hello
    I need A dynamic chart like April sheet and March sheet that depend to filter Journal sheet

    source data is : Journal sheet --> Column R

    when I filter table in journal sheet such as March 2023 then line chart show me line of column R
    or when I filter table in journal sheet such as April 2023 then line chart show me line of column R & etc
    it means line chart will be show variable data of column R in journal sheet

    in the chart in vertical column number start from 100% or 100 simple




    Thank you in advance
    Attached Files Attached Files
    Last edited by soubasa; 05-06-2023 at 10:31 AM.

  2. #2
    Forum Contributor
    Join Date
    04-16-2020
    Location
    Tehran, Iran
    MS-Off Ver
    2019 v2306
    Posts
    145

    Re: Dynamic Line Chart For Variable Table

    Solved by this code :

    =SUBTOTAL(109,[@[% Result]])

  3. #3
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,571

    Re: Dynamic Line Chart For Variable Table

    Note that I was working on this when post #2 was made, however I will post my proposal for the benefit of anyone that may need the extra information.
    Perhaps this will help.
    1. Add a column (U) to Table2 which is populated using: =SUBTOTAL(9,[@[Signal Time]])
    2. Populate column C on the March using: =IFERROR(INDEX(Table2[% Result],AGGREGATE(15,6,(ROW(Table2[% Result])-ROW(Table2[#Headers]))/(Table2[Chart]>0),ROWS(C$2:C2)))*100,"")
    3. Populate column D using: =IF(C2="",NA(),C2+D1)
    4. The graph on the March sheet references column D
    Test by changing the filter in the Signal Time column.
    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  4. #4
    Forum Contributor
    Join Date
    04-16-2020
    Location
    Tehran, Iran
    MS-Off Ver
    2019 v2306
    Posts
    145

    Re: Dynamic Line Chart For Variable Table

    Thank you for your time
    Your comments will definitely be helpful and I will make the most of your kindness
    Your work was very valuable, especially the Chart Title
    Also I attached my Chart


    I sincerely appreciate your help
    Please Accept My Deepest Thanks
    Attached Files Attached Files

  5. #5
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,571

    Re: Dynamic Line Chart For Variable Table

    You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.

+ 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. [SOLVED] Convert Line Chart to a Dynamic Chart
    By mgs in forum Office 365
    Replies: 3
    Last Post: 09-08-2021, 06:00 AM
  2. Dynamic line chart
    By BWellman in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-04-2016, 08:43 AM
  3. Adding a Dynamic "Target Threshold line" to a Pivot table and chart
    By ImokatExcel in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-30-2016, 03:02 PM
  4. VBA - Updating Dynamic Line Chart & Inserting Dynamic Formula
    By bruno08102013 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-09-2014, 10:10 AM
  5. Dynamic Range Column Chart w/ Dynamic Avg Line (Excel 2007)
    By BrokenBiker in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 10-04-2012, 11:40 AM
  6. Dynamic Line Chart
    By hambone in forum Excel General
    Replies: 14
    Last Post: 05-21-2010, 11:10 AM
  7. Line Chart with Dynamic Range
    By cwik in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 05-24-2007, 07:21 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