Skip to Content
0
Former Member
Jul 07, 2009 at 04:24 PM

Best Practice Advice for Xcelsius Beginner

30 Views

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.