Skip to Content
0
Former Member
Dec 05, 2009 at 01:24 AM

Can we use Excel Macros and import that Excel file into Xcelsius?

40 Views

Hi,

I have a scenario where I created a Webi report for various Countries vs Sales vs Weeks in a year.

I need to create a Line chart in Xcelsius such that when i select a Country , the Sales for all the weeks in a year is displayed in Line chart.

So I put a destination ( target ) no. of rows in Excel file and the imported the Crosstab tables (created in Webi) for Week nos. and Sales with Country as a Section. ( Using Live Office Connection) When the user selects the country the corresponding crosstab table should get populated into the Destination(target) no. of rows. I want to map that target no. of rows to Xcelsius Line chart component. So my question is Can i write a macros for populating the target rows depending on user selection and then go ahead and map it to Xcelsius? Is Xcelsius compatible with macros?? Please reply.

Here is a link to the sample report of what I have created.

http://spreadsheets.google.com/ccc?key=0ArtH2PxMq8GXdDVfeWtneEQ4eVIyY1BtSlpySzRaS2c&hl=en