For our dashboard, we will add a bar chart showing revenue over time to enhance our revenue table. Then, we'll layer over a line to show net income as a complement to revenue. With this technique, we can show income, even when it's technically a loss, against revenue.
Let's start building our bar chart. To build a revenue chart, follow these steps:
Open the GP 2016
Dashboard.xlsx
file that we've been working with.Select the Dashboard worksheet.
Highlight cells D7 through H8. They should contain the revenue and net income information from the table.
Select the Insert tab from the ribbon.
Select the icon for Combo Charts from the ribbon:
The bar chart will automatically appear. Use your mouse to drag the new chart directly under the revenue table:
Click anywhere on the chart (select), and the handle bars will appear around the chart. This will open a new menu option called Chart Tools:
If your Revenue shows up as the bars and your Net Income shows as the line, your fine...