Below is a possible solution to the challenge - Challenge 5 – Prepare a Graphical Chart

1. Download the Challenge file - Tiger Count

2. Right click on Tiger's picture > Cut > Open Microsoft Paint or any other picture editor> Paste > Save the picture

3. Select A1:B7 in Tiger Count file.

4. Create a column chart.

5. Remove vertical and horizontal lines, if any, by selecting them and deleting them.

6. Click anywhere in the graph > Design tab > Add Chart Elements > Data Labels > Outside End

7. Click any data label > Home tab > Fill with black Colour > Bold the Text and make Font White. Adjust font size, if needed.

8. Right Click on any data label > Format Data Axis > Size & Properties > Text Direction > Rotate All Text 270

1

9. Right Click on x axis and repeat step 7 for x axis also.

10. Select Title Box > Fill with Green Colour > Bold the Text and make Font Color White

11. Click anywhere in the graph > In the Fill, select Picture or Texture Fill > Insert Picture from File > Select the Picture of Tiger (At this stage, Excel may try to connect to internet. Choose Work offline here)

1

12. Right click on any column and fill it with White Colour.

The solution worksheet can be downloaded from here - Solution -Challenge 5 – Prepare a Graphical Chart