Instead of spreading out our data to the point where we have information overload, perhaps we could remove a few objects and produce a better dashboard? I experimented by saving Executive Dashboard under a new name. Then, I made a copy of the Sales Analysis dashboard and started editing.
Note
To make a copy of a sheet, right-click on the sheet that you want to copy in a vacant area and choose Copy Sheet.
When I finished, my new sheet, Copy of Sales Analysis, looked like the following screenshot:
Figure 5-7: The new version of Sales Analysis sheet of the Executive dashboard
I chose to move the Customer Profitability table to its own tab because, although it is related to Sales, it is really a separate investigation and thought process. Either graph is acceptable, but I chose to keep Rolling Average Sales to Margin since it does show the year and month for the data represented. I moved the multi box group to the side, where the titles are not hidden. If we...