# Mastering Excel Charts: 8 Tricky Exercises for Practice

In this tutorial, you’ll be presented with eight challenging Excel chart exercises to enhance your skills. To approach these problems effectively, you should have at least an intermediate level of knowledge in Excel. Additionally, familiarity with functions like UNIQUE and COUNTIF, as well as skills in inserting scroll bars, working with chart elements, creating pie charts, making line charts, and building bar charts, will be beneficial. Make sure you’re using the latest version of Excel (Microsoft 365) to solve all the exercises.

## Problem Overview

The eight exercises are based on a dataset with seven columns representing a company’s sales journal. The solutions for these exercises are provided in the Solution sheet of the Excel file.

• Exercise 01 – Adjust Gridline Color in Excel Charts
• Create a 3-D Column Chart using the Date and Sales columns.
• Display Primary Major Vertical Gridlines.
• Set the color of the Primary Major Horizontal Gridlines to Red.
• Exercise 02 – Create a Combo Chart
• Exercise 03 – Pie Chart by Count of Values
• Exercise 04 – Copy Chart in Excel without Linking Data
• Exercise 05 – Change Chart Style
• Create a 2D Clustered Bar chart using data from the Invoice and Cost columns.
• Add Axis Titles, Data Labels, and change the Chart Title.
• Apply “Style 12” to the chart.
• Solution: Change Chart Style.
• Exercise 06 – Scroll Bar in Chart
• Exercise 07 – Add Secondary Axis to Chart
• The following animated image shows the option to move the Misc. Fees on the Secondary Axis.

• Exercise 08 – Millions on Data Labels
• Copy the Invoice and Sales columns.
• Change the format of the Sales column.
• Insert a chart to display the data.

This image shows the solution to exercise 3.

Get FREE Advanced Excel Exercises with Solutions!

Rafiul Haq

Rafiul Haq worked as an Excel and VBA Content Developer in Exceldemy for over two years and published almost 200 articles for the website. He is passionate about exploring new aspects of Excel and VBA. He received his Bachelor of Science in Mechanical and Production Engineering (MPE) from the Islamic University of Technology. Rafiul furthered his education by obtaining an MBA in Finance from the Institute of Business Administration (IBA) at the University of Dhaka. Apart from creating... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF