How to create an dynamic chart for multiple worksheets

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/1omx6tavuV9Ulso1vVC_N8fPqLkxv5B0t/view?usp=sharing

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

matrix said:

Hello Excel supporters... https://drive.google.com/file/d/1omx6tavuV9Ulso1vVC_N8fPqLkxv5B0t/view?usp=sharing

Click to expand...

View attachment COT_TRADING_CLASSES_VG2.xlsmView attachment COT_TRADING_CLASSES_VG2.xlsm

View attachment COT_TRADING_CLASSES_VG2.xlsm

Click to expand...

I am not sure if anyone can point me to the right direction....

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!