Things You'll Need
- Microsoft Excel
- SQL or other database
- Free dashboard software
- Visual Basic
Upload data into an Excel spreadsheet. The first row should contain content headings, and the following rows are for data. Be sure to name the spreadsheet without using spaces or other characters; instead replace spaces with a “_” symbol.
Create an outline of how you want the dashboard to look. This will depend on what data you are tracking and who will be looking at the dashboard. You will use this later to place the charts and graphs in the final product.
Write formulas in Excel to turn your data into charts. The formula you need will depend on what you are charting and how you need to arrange it; You will find a link to a collection of Excel formulas in the Resources section.
Use Excel tools such as formatting, form control, objects and graphs to create the dashboard. You can find all these tools in Excel by selecting Menu > View > Tool Bars. It is possible to create a dashboard using only the tools available in Excel, but if you have an understanding of other programming software or languages, those may be helpful for creating more visually appealing or interactive dashboards.
Update your data to update the dashboard. You can choose how frequently you need to do this.
Upload data into Excel spreadsheet or other database. Sometimes you can simple copy and paste, but it is easier to connect Excel to the database, or enter it manually. Some software may only be compatible with certain data storage software, so check to see what you need.
Install the dashboard software of your choice.
Import the data from the database into the software. You will have to choose the specific file name and file path. Again, be sure that your document title does not contain any spaces or unusual characters.
Open the data file in the dashboard software. From here, you can use the various tools in the software to create the dashboard you need.