Stefan Yelas
New Member
Using the data provided to create a chart that functions like the one in the link provided.
That is, it will:
Link: Example dynamic chart and challenge data
Cheers
Stefan
That is, it will:
- accommodate dynamically a change to the number of series plotted when a user selects one of the 4 measures (device, gender, age and visitor type); and
- change the ranges of the plotted series (via a second user control - with multiple selection allowed).
- You may incorporate any UI controls as required to make the chart function for the user
- You cannot use more than one chart (and that also means the legend must part of the one chart object)
- VBA must not be used to make the chart dynamic
- The chart must not be a pivot chart (pivot tables may be used)
- Ideally your solution can will work in Excel online - like this one.
Link: Example dynamic chart and challenge data
Cheers
Stefan