Articles Comments

Free Excel Dashboards » Dashboard, Excel Dashboard, Excel Dashboard Software » How to build Excel Dashboards – 2

How to build Excel Dashboards – 2

Previous Step: Excel Dashboards – Part 1

Launch Dashboard Software and Connect


Launch InfoCaptor Dashboard Software on your Desktop and click on the connect button on the toolbar

Connection wizard for Excel Dashboard

The connection wizard has items that simplify connecting to different data sources.

For Excel Files, Click on the Excel button

Image

Once you click, it automatically selects the appropriate Driver for you

Image

Click on the “Access/Excel File” button.

Select the order_raw.xls file. It populates the connect name for you. But you can change this name. Connect Name is for your reference

NOTE: Make sure that the order_raw.xls file is not open in MS Excel. The Excel file is locked once you connect to it. If the file is open in MS Excel, you may get connected but not able to query and may get unpredictable results.

Now, click on the Connect button
Upon successful connection, the connection wizard disappears and a new action wizard pops up.

Next : How to build Dashboards – 3

For more information visit How to build Excel Dashboards – 2

No related posts.

Related posts brought to you by Yet Another Related Posts Plugin.

Filed under: Dashboard, Excel Dashboard, Excel Dashboard Software

Comments are closed.