Back to lesson
1. You have opened the Bullet Chart template provided by GoSkills. How would you go about adding it to your project?
Right click the Bullet Chart tab --> Move or Copy --> Check the box next to “Make a copy” --> Choose your workbook from the drop-down list
Right click the Bullet Chart tab --> Move or Copy --> Choose your workbook from the drop-down list
Left click and drag the Bullet Chart page into your workbook
2. Bullet charts show a great deal of context over some other chart types. They include Target Value, Actual Results and 3 bands for indicating poor, average and good performance. What does this chart tell us?
The actual performance still has a long way to go to exceed the “good performance” range
The actual performance has exceeded the target
The actual performance still hasn’t quite achieved the target
3. Assuming you copy the Bullet Chart template file into your workbook, link it with your data, then copy one of the charts to your dashboard, what would happen if you hid the Bullet Chart worksheet?
The chart would work, but only if you modified it to plot data in hidden cells
The chart would continue to work flawlessly
It would break as the data must be on the same worksheet
Back to the top
© 2018 GoSkills Ltd.
Skills for career advancement