Moving charts to separate sheets in Google Sheets - Real Business Scenario

Scenario Mode

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

📋 Request: Your manager wants a clear report showing monthly sales trends with charts on separate sheets for easy presentation.

📊 Data: You have monthly sales data for three products over six months in a table.

🎯 Deliverable: Create line charts for each product's monthly sales and move each chart to its own separate sheet named after the product.

Sample Data

Month	Product A	Product B	Product C
Jan	120	90	100
Feb	130	95	110
Mar	125	100	105
Apr	140	105	115
May	150	110	120
Jun	160	115	130

1

Step 1: Select the data range for Product A including the Month column (A1:B7).

Highlight cells A1:B7.

Expected Result

Cells A1:B7 are selected.

2

Step 2: Insert a line chart for Product A sales over months.

Insert > Chart, Chart type: Line chart.

Expected Result

A line chart showing Product A sales from Jan to Jun appears on the sheet.

3

Step 3: Move the Product A chart to a new sheet named 'Product A'.

Click chart menu > Move to own sheet > Name the sheet 'Product A'.

Expected Result

The chart is moved to a new sheet named 'Product A'.

4

Step 4: Repeat steps 1-3 for Product B using data range A1:B7 but selecting columns Month and Product B (A1:B7 is incorrect for Product B).

Select A1:A7 and C1:C7, Insert > Chart, Line chart, Move to own sheet named 'Product B'.

Expected Result

A line chart for Product B sales is created and moved to a new sheet named 'Product B'.

5

Step 5: Repeat steps 1-3 for Product C using data range A1:A7 and D1:D7 (Month and Product C columns).

Select A1:A7 and D1:D7, Insert > Chart, Line chart, Move to own sheet named 'Product C'.

Expected Result

A line chart for Product C sales is created and moved to a new sheet named 'Product C'.

6

Step 6: Rename the original data sheet to 'Sales Data' for clarity.

Right-click sheet tab > Rename > Type 'Sales Data'.

Expected Result

The data sheet is renamed to 'Sales Data'.

Final Result

Sales Data Sheet:
+-------+-----------+-----------+-----------+
| Month | Product A | Product B | Product C |
+-------+-----------+-----------+-----------+
| Jan   | 120       | 90        | 100       |
| Feb   | 130       | 95        | 110       |
| Mar   | 125       | 100       | 105       |
| Apr   | 140       | 105       | 115       |
| May   | 150       | 110       | 120       |
| Jun   | 160       | 115       | 130       |
+-------+-----------+-----------+-----------+

Product A Sheet:
(Line chart showing Product A sales Jan-Jun)

Product B Sheet:
(Line chart showing Product B sales Jan-Jun)

Product C Sheet:
(Line chart showing Product C sales Jan-Jun)

✓Each product's monthly sales trend is clearly visible on its own chart sheet.

✓Separating charts into sheets makes the report easier to present and understand.

✓Sales for all products show an increasing trend from January to June.

Bonus Challenge

Create a summary sheet with small thumbnail charts of all three products for a quick overview.

Show Hint

Use Insert > Chart and resize charts to small size, then arrange them neatly on one sheet.