Search the Community
Showing results for tags 'excel'.
Found 9 results
-
Is it possible to run an SQL query on an Excel or a csv file (that has, say, 30 columns) and generate a chart dynamically? Basically, I am looking at one chart with a drop-down of options each running an SQL query on the csv file and generating the chart. Thank you!
-
Hi, I'm trying to export the data from the chart using the context menu (to paste in Excel). <chart... showExportDataMenuItem='1' exportDataSeparator='{tab}'> I'm in Brazil and here is used comma as decimal separator, so I'm using the 'decimal option' to read the data from xml and to show the num...
-
Is there anyway we can view the code used to do the conversion from excel grid to chart data in the XML generator Utility. I am building an application and would like leverage that.
-
Hi, Are there any plans to support named ranges and tables when using the Excel data source? It is something that the OOTB SharePoint Chart web part supports and would be useful in Collabion too.
-
I am having a problem with a chart recognising dates from Excel correctly. I have a simple table in a spreadsheet which is published to SharePoint Excel Services. The table has two columns, the first are dates and the second numbers. I have selected the Excel file, sheet and table cells range in...
-
I am using Excel as my data provider and I am doing a calculation to get a percentage. I am formatting the field as a number with one decimal place. Excel Value - "0.7" When I connect to this workbook and view that data, it returns as a long whole number. Value in Collabion - "691394670108706...
-
Hello everybody, we have an Excel file where people drop their information (for example: payments). We want to create a chart that automatically refresh its data from that Excel, instead of charging the data into an XML file everytime. Is that possible? If not, could we programme the XML fil...
-
Using Excel To Compile All Files Needed For Fusion Charts Dashboard
bigfreeze posted a topic in General usage
I know someone that has developed a program in excel that will generate all of the files needed (besides the swf and java script files) to generate dashboards comprised of various charts. You use excel worksheets for your data source and though use of a template to configure and produce the files n... -
Created an page for the chart added the Collaboration chart to the center zone (this will be the only web part used on the page Launched the wizard Imported data from a csv file thats hosted in the document library completed the Wizard then clicked finished Set Rendering for Java script Click finish...