![]() It is an Excel 2010 workbook which uses a slicer to flick the dashboard between schools to show performance. The School Excel Dashboard is a dashboard which shows plan v actual for a number of schools across disciplines. The video shows the key functionality and how things can move and change just by changing a single metric. The following YouTube video is a look at what is possible using an Excel dashboard. Whether you have complex data or it is simple, interactive Excel dashboards are the ideal goal when it comes to the creation and charting process. Pay attention to the dynamism of the charts so that each data point is updatable.Īdditionally adding Slicers to your data sets allows the charts to update easily. Line Chart in Excel: These charts are great for 2 part comparisons.ĭynamic Chart in Excel: Charts that auto update, these dynamic charts can be helped with an Excel table. Pie Chart and Doughnut charts: highlight % and proportional data ![]() Heat Map chart: represent data in a dial. ![]() Waterfall chart: view how an initial value increases and decreases through a series of alterations to reach an end value ![]() Column chart a vertical chart that lays data out by time period very well.īar chart: a horizontal chart that stacks lines of data. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |