Forum Discussion
Scatter XY over quarterly results
Hi! I’m trying to chart scatter the following info: x val (volume) y val (unit price) over time (quarterly). The aim is to visualize the scatter of achieved volume @ x unit price per Q
Please provide more detailed information, preferably with an example of what the data look like and what you would like the result to be.
HansVogelaar Sure!
| Product | Volume | $ per unit | Q |
| A | 100 | $ 15.00 | Q1 22 |
| B | 150 | $ 13.50 | Q1 22 |
| C | 190 | $ 18.00 | Q1 22 |
| A | 120 | $ 14.00 | Q2 22 |
| B | 130 | $ 13.50 | Q2 22 |
| C | 180 | $ 18.00 | Q2 22 |
| A | 140 | $ 14.00 | Q3 22 |
| B | 130 | $ 13.50 | Q3 22 |
| C | 200 | $ 16.50 | Q3 22 |
| A | 135 | $ 15.00 | Q4 22 |
| B | 135 | $ 13.00 | Q4 22 |
| C | 190 | $ 17.00 | Q4 22 |
| A | 120 | $ 18.00 | Q1 23 |
| B | 160 | $ 15.50 | Q1 23 |
| C | 210 | $ 19.50 | Q1 23 |