Chart Formatting, Labels and Presentation Practice Questions with Solutions

Introduction

A good Excel chart should not only show data but also make the information easy to understand. In this chapter, you will practice chart titles, axis titles, data labels, legends, number formats, chart styles, gridlines, axis settings, and overall chart presentation. Each question uses complete Excel data and focuses on a different chart-formatting concept so you can improve your Excel reporting skills through practical examples. Chart Formatting, Labels and Presentation Practice Questions with Solutions to help you understand the concepts.

Question 1: Add a Chart Title and Axis Titles

Problem Statement

Create a column chart for monthly sales and add a suitable Chart Title, Horizontal Axis Title, and Vertical Axis Title.

Excel Data

Excel Solution

1. Select A1:B9.
2. Go to Insert → Column Chart.
3. Select Clustered Column.
4. Add the chart title:

Monthly Sales Report

5. Add the horizontal axis title:

Month

6. Add the vertical axis title:

Sales Amount (₹)

Expected Result

The chart should clearly identify:

• What the chart represents → Monthly Sales Report
• Horizontal axis → Month
• Vertical axis → Sales Amount (₹)

Concepts Covered

• Chart Title
• Axis Titles
• Column Chart
• Chart presentation

Question 2: Add Data Labels to a Sales Chart

Problem Statement

Create a column chart and display the exact sales value above every column using Data Labels.

Excel Data

Excel Solution

1. Select A1:B7.
2. Go to Insert → Column Chart.
3. Select Clustered Column.
4. Click the chart.
5. Go to Chart Design → Add Chart Element → Data Labels.
6. Select Outside End.
7. Add the chart title:

Product Sales

Expected Result

The exact sales amount should appear above each column.

For example:

Laptop    ₹450000
Mobile    ₹320000
Tablet    ₹185000

Concepts Covered

• Data Labels
• Column Chart
• Chart Elements
• Sales Reporting

Question 3: Format Data Labels as Currency

Problem Statement

Create a column chart for monthly revenue and format the data labels so that they display the values as Indian currency.

Excel Data

Excel Solution

1. Select A1:B9.
2. Insert a Column Chart.
3. Add Data Labels.
4. Right-click any data label.
5. Select Format Data Labels.
6. Open Number.
7. Select Currency or use a suitable custom number format.
8. Add the chart title:

Monthly Revenue

Expected Result

The data labels should display revenue values in a currency format instead of plain numbers.

Concepts Covered

• Data Labels
• Number Formatting
• Currency
• Format Data Labels

Question 4: Format the Vertical Axis Using Thousands

Problem Statement

Create a column chart for annual sales and format the vertical axis so that large numbers are easier to read.

Excel Data

Excel Solution

1. Select A1:B7.
2. Insert a Column Chart.
3. Right-click the vertical axis.
4. Select Format Axis.
5. Set the appropriate Display Units, such as Thousands.
6. Add the axis title:

Sales (₹ Thousands)

7. Add the chart title:

Annual Sales Growth

Expected Result

Instead of displaying very large numbers on the vertical axis, Excel will show the values using a more compact scale.

Concepts Covered

• Format Axis
• Display Units
• Thousands
• Axis Title
• Large-number presentation

Question 5: Format the Chart Legend

Problem Statement

Create a line chart showing Sales and Expenses. Format the Legend so users can easily identify both lines.

Excel Data

Excel Solution

1. Select A1:C9.
2. Go to Insert → Line Chart.
3. Select 2-D Line.
4. Add the chart title:

Sales and Expenses

5. Add a Legend.
6. Position the Legend at the Bottom of the chart.

Expected Result

The chart should contain two lines:

• Sales
• Expenses

The Legend at the bottom should clearly identify each line.

Concepts Covered

• Legend
• Line Chart
• Multiple Series
• Chart Elements
• Chart Layout

Question 6: Format Gridlines for Better Readability

Problem Statement

Create a line chart for website visitors and adjust the gridlines so the values can be read easily.

Excel Data

Excel Solution

1. Select A1:B9.
2. Insert a Line Chart.
3. Add the title:

Monthly Website Visitors

4. Select the chart.
5. Go to Chart Design → Add Chart Element → Gridlines.
6. Keep the Primary Major Horizontal Gridlines.
7. Remove unnecessary gridlines if they make the chart difficult to read.

Expected Result

The chart should have enough horizontal gridlines to help compare visitor numbers without making the chart look crowded.

Concepts Covered

• Gridlines
• Line Chart
• Chart readability
• Chart presentation

Question 7: Format a Line Chart with Markers

Problem Statement

Create a line chart showing monthly temperature and display markers for each month’s value.

Excel Data

Excel Solution

1. Select A1:B13.
2. Go to Insert → Line Chart.
3. Select a Line with Markers chart.
4. Add the title:

Monthly Temperature

5. Add the vertical axis title:

Temperature (°C)

Expected Result

Each month’s temperature should appear as a point on the line.

Concepts Covered

• Line with Markers
• Data Points
• Axis Titles
• Chart Presentation

Question 8: Change the Chart Style and Layout

Problem Statement

Create a column chart showing product sales and apply a suitable built-in Chart Style and Chart Layout.

Excel Data

Excel Solution

1. Select A1:B8.
2. Insert a Column Chart.
3. Select the chart.
4. Go to Chart Design.
5. Choose a suitable Chart Style.
6. Open Quick Layout.
7. Select a layout containing:
   • Chart Title
   • Axis Titles
   • Data Labels
8. Use this chart title:

Product Units Sold

Expected Result

The chart should have a clean layout with the important chart elements visible without unnecessary elements.

Concepts Covered

• Chart Styles
• Quick Layout
• Chart Design
• Data Labels
• Axis Titles

Question 9: Format a Chart for a Professional Report

Problem Statement

Create a chart for quarterly company revenue and format it so it can be used in a business report.

Excel Data

Excel Solution

1. Select A1:D5.
2. Insert a Combo Chart.
3. Set:
   • Revenue → Column
   • Expenses → Column
   • Profit → Line
4. Add the chart title:

Quarterly Financial Performance

5. Add the horizontal axis title:

Quarter

6. Add the vertical axis title:

Amount (₹)

7. Add a Legend.
8. Add Data Labels to the Profit line.
9. Remove unnecessary chart elements.
10. Select a clean built-in Chart Style.

Expected Result

The final chart should clearly show Revenue, Expenses, and Profit without unnecessary visual elements.

Concepts Covered

• Combo Chart
• Chart Formatting
• Data Labels
• Axis Titles
• Legend
• Professional Presentation

Question 10: Format a Complete Dashboard Chart

Problem Statement

Create a sales chart that contains a title, axis titles, data labels, legend, and appropriate number formatting. The final chart should be suitable for an Excel dashboard.

Excel Data

Excel Solution

1. Select A1:C13.
2. Insert a Line Chart.
3. Add the chart title:

Online and Store Sales Performance

4. Add the horizontal axis title:

Month

5. Add the vertical axis title:

Sales Amount (₹)

6. Add a Legend.
7. Place the Legend at the Bottom.
8. Add Data Labels to the lines if the chart remains readable.
9. Format the axis numbers appropriately.
10. Keep useful horizontal gridlines.
11. Remove unnecessary chart elements.
12. Apply a clean built-in Chart Style.

Expected Result

The final chart should clearly show the difference between Online Sales and Store Sales throughout the year.

The chart should contain:

• Chart Title
• Axis Titles
• Two data series
• Legend
• Appropriate number formatting
• Useful gridlines
• Data Labels where they improve readability

Concepts Covered

• Complete Chart Formatting
• Line Chart
• Data Labels
• Legend
• Axis Titles
• Number Formatting
• Gridlines
• Chart Style
• Dashboard Presentation

Key Takeaways

• A Chart Title tells the reader what the chart represents.
• Axis Titles explain what each axis represents.
• Data Labels display the actual values directly on the chart.
• A Legend identifies different data series.
• Gridlines can make values easier to compare.
• Chart Styles provide ready-made formatting options.
• Quick Layout can quickly add or arrange chart elements.
• Number formatting can make large values easier to understand.
• Too many labels or chart elements can make a chart difficult to read.
• A professional chart should focus on clarity rather than unnecessary decoration.

FAQs

1. What is Chart Formatting in Excel?

Chart Formatting means changing the appearance and layout of a chart, including its title, labels, axes, legend, gridlines, styles, and number formats.

2. What are Data Labels in Excel?

Data Labels display the actual value of a data point directly on a chart.

3. Why are Axis Titles important?

Axis Titles explain what the horizontal and vertical axes represent, making the chart easier to understand.

4. What is a Legend in an Excel Chart?

A Legend identifies different data series in a chart. For example, a chart containing Online Sales and Store Sales can use the Legend to identify both lines.

5. Can I change the position of the Legend?

Yes. Excel allows you to position the Legend at locations such as:

• Right
• Left
• Top
• Bottom

6. What are Gridlines used for?

Gridlines help readers compare chart values with the scale on the axis.

7. Can I format numbers displayed in Data Labels?

Yes. Data Labels can be formatted using options such as number, currency, percentage, decimal places, and custom number formats.

8. What is Quick Layout in Excel?

Quick Layout provides predefined combinations of chart elements such as titles, axis titles, legends, and data labels.

9. Should every chart have Data Labels?

Not necessarily. Data Labels are useful when exact values are important, but too many labels can make a chart crowded.

10. How can I make an Excel chart look professional?

Use a clear title, meaningful axis titles, appropriate number formatting, a readable legend, useful gridlines, and only the chart elements needed to understand the data.

Written by Shubhranshu Shekhar, who has trained 20000+ students in coding.

Rishabh Kumar