• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Create a dynamic chart for the number series and series ranges

Not open for further replies.

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:
  • 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).
The rules:
  • 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.
The data can be copied directly from the same link.

Link: Example dynamic chart and challenge data




Excel Ninja
Staff member

I note this is now cross posted

Please read the site rules
Not open for further replies.