I am an accounting intern working with Excelsius for the first time. I am trying to use Excelsius to display a Column Chart and then I can select under a List component to where I can select between either displaying Monthly Data or Weekly Data.
So you know what I am working with, my rows are headed by the month or week that the data is obtained from, and then my columns consists payments from different sources. So I want this list to be able to select either the monthly or weekly data and then select which payment source I want to show.
I tried using an accordion menu; however, my monthly data consists of 9 months and my weekly data consists of 45 weeks. So when I select the monthly data to display on my chart I have the first 9 columns' information and then have 36 remaining "values" where it is a "zero". And then when I select weekly data, all 45 columns are filled with the data and the chart is complete.
If anyone could point me in some direction I would be very grateful. Thank you
-Scott Gadd