Moving and resizing charts in Excel - Real Business Scenario

Scenario Mode

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

📋 Request: Your manager wants a clear sales performance chart on the monthly report sheet. The chart must be moved to a specific location and resized to fit neatly without overlapping other data.

📊 Data: You have monthly sales data for four products from January to June in a table format.

🎯 Deliverable: A column chart showing monthly sales for all products, moved to the top right corner of the report sheet and resized to 600 pixels wide and 400 pixels tall.

Sample Data

Month	Product A	Product B	Product C	Product D
Jan	120	150	100	130
Feb	135	160	110	140
Mar	150	170	120	150
Apr	160	180	130	160
May	170	190	140	170
Jun	180	200	150	180

1

Step 1: Select the data range including headers and months (A1:E7).

Select cells A1 to E7.

Expected Result

Data range selected for chart creation.

2

Step 2: Insert a column chart based on the selected data.

Go to Insert tab > Charts group > Insert Column or Bar Chart > Clustered Column.

Expected Result

A column chart appears on the sheet showing monthly sales for all products.

3

Step 3: Move the chart to the top right corner of the sheet.

Click and drag the chart to position it starting near cell G1.

Expected Result

Chart is positioned at the top right corner without overlapping the data table.

4

Step 4: Resize the chart to be 600 pixels wide and 400 pixels tall.

Click the chart, then drag the edges or use Format Chart Area > Size options to set Width=600 px and Height=400 px.

Expected Result

Chart size is adjusted to 600x400 pixels, fitting neatly in the designated area.

Final Result

Monthly Sales Report

+---------------------------------------------+
|                                             |
|           [Column Chart: Sales]              |
|                                             |
|                                             |
|                                             |
|                                             |
|                                             |
+---------------------------------------------+

Data Table:
Month | Product A | Product B | Product C | Product D
-----------------------------------------------------
Jan   | 120       | 150       | 100       | 130
Feb   | 135       | 160       | 110       | 140
Mar   | 150       | 170       | 120       | 150
Apr   | 160       | 180       | 130       | 160
May   | 170       | 190       | 140       | 170
Jun   | 180       | 200       | 150       | 180

Bonus Challenge

Add data labels to each column in the chart to show exact sales numbers.

Show Hint

Select the chart, go to Chart Elements (plus icon), check Data Labels, and choose the position 'Outside End'.