I want to create a dynamic chart.
I have 6 series of values: each represent the maximum displacement for 6 different earthquakes. I want the chart to change according to one column (column B), which basically contains 5 possible values: 5, 10, 15, 20 and 25.
Therefore the chart needs to plot columns D vs F, for the 6 series of column C. The chart should change dynamically, according to value of column B.
An expert previously helped me, using OFFSET formula. I just need some help to continue the work for creation of my dynamic chart.
Name taggs have been previously used. I am not sure on why to use it for this problem and need explanations.
Solved by M. U. in 28 mins