Scatter XY over quarterly results

Question

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&nbsp;

hansvogelaar · Answer

Kamukase19&nbsp;
Please provide more detailed information, preferably with an example of what the data look like and what you would like the result to be.

kamukase19 · Answer

HansVogelaar&nbsp; Sure!&nbsp;ProductVolume$ per unitQA100&nbsp;$&nbsp;&nbsp; 15.00Q1 22B150&nbsp;$&nbsp;&nbsp; 13.50Q1 22C190&nbsp;$&nbsp;&nbsp; 18.00Q1 22A120&nbsp;$&nbsp;&nbsp; 14.00Q2 22B130&nbsp;$&nbsp;&nbsp; 13.50Q2 22C180&nbsp;$&nbsp;&nbsp; 18.00Q2 22A140&nbsp;$&nbsp;&nbsp; 14.00Q3 22B130&nbsp;$&nbsp;&nbsp; 13.50Q3 22C200&nbsp;$&nbsp;&nbsp; 16.50Q3 22A135&nbsp;$&nbsp;&nbsp; 15.00Q4 22B135&nbsp;$&nbsp;&nbsp; 13.00Q4 22C190&nbsp;$&nbsp;&nbsp; 17.00Q4 22A120&nbsp;$&nbsp;&nbsp; 18.00Q1 23B160&nbsp;$&nbsp;&nbsp; 15.50Q1 23C210&nbsp;$&nbsp;&nbsp; 19.50Q1 23&nbsp;&nbsp;

Forum Discussion

Scatter XY over quarterly results

2 Replies

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