Dynamic variables in a chart|Dashboards & Charts|Excel Forum|My Online Training Hub

Hi all,

I originally thought Excel would handle this through normal function, but after trial and error and I'm thinking what I want to do will only be possible with VBA, or I'm missing something subtle.

I have a set of data (call it B) that is pulling from an original set of data (call it A). Data set A has a lot of variables that would be too overwhelming to chart, so I'm having data B rank data set A, and then charting data set B. The point of the chart is to monitor trends overtime, so I'm graphing the top five values every period over a year.

 The thing is that Excel doesn't account for the fact that the variables it is graphing are changing over time. Whatever the variable is from the first period is what it goes with for the rest of the year.

 Does anyone know how to get the chart I want, either through normal function or through VBA? I've attached a generic example.

Thank you,