Skip to Content
author's profile photo Former Member
Former Member

Need Help! Using multiple combo boxes to change mutiple charts...

Hi guys,

I am trying to create a prototype for my team that will involve using multiple combo boxes (i.e. Type, Category, Year) to modify multiple graphs (i.e. Stacked Colum Chart & Pie Chart). I was looking for an example that I could refer to for help.

I have tried using the "Filtered Rows" option, but keep hitting a wall when I try to modify more than one graph when selecting different values from the combo boxes.

Also, should I use a filter instead of combo boxes? Is this scenario even possible in Xcelsius?

Please advise. Thanks.

Regards,

Ahmed

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Apr 20, 2011 at 03:18 AM

    Hi Ahmed,

    Firstly, what you're describing is certainly possible in Xcelsius.

    Could you explain your data source, or is this a template with 'fake' data?

    You can use combo boxes to filter data in charts, or even the charts themselves. Here's a post on filtering data in charts like that: http://blog.davidg.com.au/2011/04/xcelsius-interactivity-chart-drill-down.html

    But if you do want combo boxes, then your data arrangement might be something like this:

    Three ranges for the three combo boxes, for Type, Category, Year.

    One range for your data source. In it's simplest form this could be a flattened table with four columns: Type, Category, Year and a measure, let's say 'Sales'.

    Take the selected values from the three drop downs and concatenate them.

    Take the first three columns from you source data and concatenate them.

    Then use a lookup to see which data should show in the charts. So if a user selects 'Mountain', 'Bikes', '2011' then your vlookup/index function would pick out only the rows in your data for MountianBikes2011.

    The cells that contain these formulas then become the source for your charts.

    Hope that makes sense.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.