Using the Sample-superstore, plan to create a dashboard showing the sales and profits for different segments and Sub-Category of products across all the states. So when you modify the worksheet, the dashboard is updated and when you modify the view in the dashboard, the worksheet is updated. While creating a dashboard, you can add views from any worksheet in the workbook along with many supporting objects such as text areas, web pages, and images.Įach view you add to the dashboard is connected to its corresponding worksheet. Dashboards are shown as tabs at the bottom of the workbook and they usually get updated with the most recent data from the data source. The different data views are displayed all at once. It is used to compare and monitor a variety of data simultaneously. A dashboard is a consolidated display of many worksheets and related information in a single place.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |