Hello, all -
This is my first post to the community. Please forgive my naivety. : )
I've read about half of the 400 page Xcelsius manual, and am still confused about using individual cells to comprise a series. My client has a ready-made Excel spreadsheet generated from Crystal Reports that I am using within Xcelsius Engage.
Specifically, I am trying to build an easily reusable Xcelsius document that does not require the spreadsheet to be changed (additional functions/formulas). I would like my client's admin to be able to just copy and paste the data into Xcelsius and publish.
But when I try to use 3 separate calls to comprise the values of a series (to calculate total revenue), the text box in my line chart properties doesn't display my selection. My question boils down to this: Is it best to custom design a spreadsheet (and require my client to invest additional human resources), or is it best to strive for advanced Xcelsius programming and just use a ready-made spreadsheet?
Thanks in advance for any help.