Results 1 to 5 of 5

Thread: How to create an dynamic chart for multiple worksheets

  1. #1
    Acolyte matrix's Avatar
    Join Date
    Dec 2019
    Posts
    28
    Articles
    0
    Excel Version
    2019

    How to create an dynamic chart for multiple worksheets



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello Excel supporters...

    I am not sure if anyone is willing to help me.

    I have little to no knowledge when it comes to working with dynamic charts.

    Below. I have an excel workbook sample file for viewing.

    Currently it has 14 tabs which has its own personal table data entry.

    Each worksheet chart gets its data only in column A "Dates"; column H "Flip" and column I "Price"

    The "Dates" on the "X axis" and the

    "Flip" and the "Price" on the Y axis where the center of the chart, values are set on zeros on both sides or left and right (Flip & Price)

    How can I create a dynamic chart to achieve this?

    What do I need to do to get this done?

    Would you help me?


    Thanks in advance...

    Cheers

    https://drive.google.com/file/d/1omx...ew?usp=sharing

  2. #2
    Admin Alumnus Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,755
    Articles
    0
    Excel Version
    2010 on Xubuntu
    Hi
    please post your sheet on the forum, external links are untrustworthy and not all members may be able to access them, depriving you of valuable help
    Thanks
    Thank you Ken for this secure forum.

  3. #3

  4. #4
    Acolyte matrix's Avatar
    Join Date
    Dec 2019
    Posts
    28
    Articles
    0
    Excel Version
    2019
    I am not sure if anyone can point me to the right direction....

  5. #5
    Conjurer Ed Kelly's Avatar
    Join Date
    Jul 2016
    Posts
    182
    Articles
    0
    Excel Version
    2016
    If you have not already solved this. Check out this puppy. Not sure if either hits the mark.

    https://www.screencast.com/t/OG0RKcZQ

    Knock 'em dead Sailor!
    Attached Files Attached Files

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •