Hi, everybody.
I’ve encountered problem, and I couldn’t find any solution yet.
The case is that, my data set(result set/excel table) is changing according to parameters user passes. Ex: if a period of time is 30 days, I will get 60 records. When I try to map this records to a CHART(component, ex: Line Chart) I get normal Chart, but if I change period to bigger period, lets say 60 days, the data on Chart is not changing, or if less records, chart shows half of the chart empty. I guess Xcelsius just doesn’t understand that result set is changing and it keep mapping the same range.
Xcelsius is supposed to map the same range all the time. What you have to do is make that range dynamic so it shows the data you want to display and only that data.
A lot of it depends on how you are getting your data into the range to be mapped. Ideally, you pre-aggregate your data so you only ever have a fixed-size data set (eg: 12 monthly totals for a year).
Make sure you have the check boxes in “Ignore Blank Cells” ticked. This way, if you map 60 rows but only have 30 rows of data, the graph will only show 30 rows of data.
(BOB member since 2005-03-01)