Excel

Excel Dashboards - Launch Designer and Connect to Excel



In the Previous article we briefly mentioned the benefits of Excel based dashboard We continue the series in building the dashboard This is the sample Excel Spreadsheet test_data.xls Launch InfoCaptor Connect to the Excel file If the path of the Excel file is "c:\files\data.xls" then use "\\" , result c:\\files\\data.xls In this case the file to ...

Excel Dashboard - Charts, Gauges, Tables and Drills, Reports



There are two ways to create Dashboards using Excel Data. One way is to create the tables and charts right in the Excel file using the Excel functionality and the other way is to connect to Excel file as if you are connecting to a Database and then create Charts, ...