+ Reply to Thread
Results 1 to 4 of 4

Convert Line Chart to a Dynamic Chart

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

    Convert Line Chart to a Dynamic Chart

    The Line Graph in the attached workbook is not dynamic.

    I can't make it Dynamic, but can anyone else do it?

    Feel free to modify the attached workbook.

    mgs
    Attached Files Attached Files
    Last edited by mgs; 09-08-2021 at 03:57 AM. Reason: Solved
    Reply With QuoteRegister To Reply
  2. 09-08-2021, 03:28 AM #2
    KOKOSEK
    KOKOSEK is offline
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    2,742

    Re: Convert Line Chart to a Dynamic Chart

    Dynamic range created and applied into data series.
    Check attached file.
    Attached Files Attached Files
    Happy with my answer * Add Reputation.
    If You are happy with solution, please use Thread tools and mark thread as SOLVED.
    Reply With QuoteRegister To Reply
  3. 09-08-2021, 03:55 AM #3
    mgs
    mgs is offline
    Registered User
    Join Date
    02-20-2011
    Location
    Queensland, Australia
    MS-Off Ver
    Office 365
    Posts
    71

    Re: Convert Line Chart to a Dynamic Chart

    Thanks KOKSEK,
    It works a treat.

    Thanks,
    mgs
    Reply With QuoteRegister To Reply
  4. 09-08-2021, 06:00 AM #4
    KOKOSEK
    KOKOSEK is offline
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    2,742

    Re: Convert Line Chart to a Dynamic Chart

    Happy to help.
    Thanks for rep.
    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. Dynamic line chart
    By BWellman in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-04-2016, 08:43 AM
  2. 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
  3. [SOLVED] Chart Lengend to show marker style on hidden line - Line chart
    By etaf in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 08-22-2013, 05:19 PM
  4. 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
  5. Dynamic Line Chart
    By hambone in forum Excel General
    Replies: 14
    Last Post: 05-21-2010, 11:10 AM
  6. Dynamic X Axis in line chart
    By craigproudfoot in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 11-02-2009, 12:43 PM
  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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1