Multiple Groups Graph on Google Sheets. Please Help

Question

I got the following table on google sheets.

---

Text version

+----+---+---+----+
|    | A | B | C  |
+----+---+---+----+
| 1  | 1 | 2 | 1  |
+----+---+---+----+
| 2  | 2 | 1 | 1  |
+----+---+---+----+
| 3  | 3 | 1 | 4  |
+----+---+---+----+
| 4  | 3 | 2 | 7  |
+----+---+---+----+
| 5  | 3 | 3 | 8  |
+----+---+---+----+
| 6  | 3 | 4 | 1  |
+----+---+---+----+
| 7  | 4 | 1 | 3  |
+----+---+---+----+
| 8  | 4 | 2 | 4  |
+----+---+---+----+
| 9  | 4 | 3 | 13 |
+----+---+---+----+
| 10 | 4 | 4 | 1  |
+----+---+---+----+
| 11 | 4 | 5 | 3  |
+----+---+---+----+
| 12 | 5 | 3 | 5  |
+----+---+---+----+
| 13 | 5 | 4 | 14 |
+----+---+---+----+
| 14 | 5 | 5 | 5  |
+----+---+---+----+
| 15 | 5 | 3 | 8  |
+----+---+---+----+
| 16 | 6 | 4 | 27 |
+----+---+---+----+
| 17 | 6 | 5 | 16 |
+----+---+---+----+
| 18 | 5 | 5 | 1  |
+----+---+---+----+
| 19 | 7 | 4 | 4  |
+----+---+---+----+
| 20 | 7 | 5 | 1  |
+----+---+---+----+
| 21 | 8 | 3 | 2  |
+----+---+---+----+
| 22 | 8 | 4 | 72 |
+----+---+---+----+
| 23 | 8 | 5 | 55 |
+----+---+---+----+

---

I want the first column to represent the groups in x axis. The 2nd column is supposed to be the a group in a certain x value lets say I have

8 3 22

8 4 55

8 5 72

I want to have at value x = 8 , 3 bars, the first bar has the y value of 22 with the label 3, the 2nd has y value of 22 with label 4, and the 3rd has y value of 72 with label 5.

This is the chart I got which is completely not the one I wanted.

Answer 1

Format your chart as follows:

• Highlight cells A1:C23

• From the Main menu, choose Insert, Insert Chart.

• Double-click the chart and make the following changes:

• Setup

  • Chart Type: Column Chart
  • Stacking: None
  • Data Range: A1:C23 (for confirmation)
  • X-Axis: A1:A23 (for confirmation)
  • Series:
    • B1:B23 - Remove
    • C1:C23 - Add Labels, select the range B1:B23

• Customise

  • Chart & axis titles
    • Edit according to your needs
  • Horizontal Axis
    • Treat labels as text - Tick the box
  • Vertical Axis
    • Treat labels as text - Tick the box if not already ticked
    • Show Axis Line - Tick the box if not already ticked
  • Gridlines and ticks
  • Vertical Axis
    • Major gridlines - Tick the box if not already ticked
    • Minor gridlines - Tick the box if not already ticked
    • Major ticks - Tick the box if not already ticked

---

Chart