Excel Services Chart Generation for SharePoint Dashboard Display

[Tracy]

Hi there,

I've got an xml/rpc datasource that I'm currently manipulating in Java to
create an Excel 2007 workbook table. I'm then referencing that Excel
workbook as the data for a second Excel 2007 workbook, constructing a pivot
table, and a number of business data charts utilizing cell formulas and
various vba macros.

I need to display these business charts within a SharePoint dashboard using
Excel services. However, vba macros will not work within Excel services and
my SharePoint Excel service web part continuously generates
warnings/confirmations regarding 'enabling queries to external data sources'
upon all data refreshes.

I've been reading exerpts about odc's and data sources within MS Excel 2007
and I'm wondering if I should just be importing the rpc/xml directly into
Excel and dynamically parsing it, to make it much more Excel
Services/SharePoint friendly.

I have some idea of how to import the rpc/xml data into Excel, but I'm not
sure how to dynamically manipulate the data without using macros. Can
someone point me in the direction of some how-tos/articles for how to do
this; keeping all the data and logic local to Excel and without using macros?

Thanks!!

 

[Tracy]

For those of you who may also have this question; I never got a response and
consequently figured it out myself.

Check out this URL:
http://msdn.microsoft.com/en-us/lib..._CreatingaUserDefinedFunctionforExcelServices

Thanks!