Formatting chart appearance in Excel - Real Business Scenario

Scenario Mode

👤 Your Role: You are a sales analyst at a retail company.

📋 Request: Your manager wants a clear and visually appealing chart to show monthly sales trends for the first half of the year.

📊 Data: You have monthly sales data from January to June with sales amounts in dollars.

🎯 Deliverable: Create a line chart showing monthly sales, then format the chart with a title, axis labels, data markers, and a color scheme that makes it easy to read.

Sample Data

Month	Sales ($)
January	1200
February	1500
March	1700
April	1600
May	1800
June	2000

1

Step 1: Select the data range including the headers (A1:B7).

Select cells A1:B7.

Expected Result

Data range with months and sales is selected.

2

Step 2: Insert a line chart to visualize monthly sales.

Go to Insert tab > Charts group > Line Chart > Choose 'Line with Markers'.

Expected Result

A line chart appears showing sales trends from January to June with data markers on each point.

3

Step 3: Add a chart title to describe the chart.

Click on the chart title area and type 'Monthly Sales Trends (Jan-Jun)'.

Expected Result

Chart title 'Monthly Sales Trends (Jan-Jun)' is displayed above the chart.

4

Step 4: Add axis titles to label the X and Y axes.

Select the chart, go to Chart Design tab > Add Chart Element > Axis Titles > Primary Horizontal and Primary Vertical. Label X axis as 'Month' and Y axis as 'Sales ($)'.

Expected Result

X axis labeled 'Month' and Y axis labeled 'Sales ($)'.

5

Step 5: Format the data markers to make them more visible.

Click on a data marker, right-click > Format Data Series > Marker Options > Built-in > Choose circle shape and increase size to 8 pt.

Expected Result

Data markers on the line chart are larger and circular, making each month's sales point clear.

6

Step 6: Change the line color to a distinct blue for better visibility.

Right-click the line > Format Data Series > Line > Color > Choose blue color.

Expected Result

The line connecting data points is blue, improving chart readability.

7

Step 7: Add gridlines for easier value reading.

Select chart > Chart Design tab > Add Chart Element > Gridlines > Primary Major Horizontal.

Expected Result

Horizontal gridlines appear behind the chart data for easier comparison of sales values.

Final Result

Monthly Sales Trends (Jan-Jun)

Month    | Sales ($)
---------------------
Jan      | *1200
Feb      |  *1500
Mar      |   *1700
Apr      |   *1600
May      |    *1800
Jun      |     *2000

(Line chart with blue line, circular markers, labeled axes, and horizontal gridlines)

✓Sales increased steadily from January to June.

✓May and June show the highest sales, indicating growth in the second quarter.

✓The chart formatting makes it easy to see monthly changes and compare values.

Bonus Challenge

Add data labels to each data point showing the exact sales value.

Show Hint

Select the chart, go to Chart Design > Add Chart Element > Data Labels > choose 'Above' to display values above each marker.