Scatter Chart

[Anonymous]

Hi,

I have two scatter charts, one showing the data for 2017 and the other one for 2018.

Dimension: Product Group (Values: A,B,C,D)

Expressions : 1. No of Quotes Approved   2. Units Requested

If 2018 is compared with 2017, Product A and D are growing , Product B is declining and for Product C one of the value is going up while the other is going down.

Header 1	Header 2	Header 3
Product	2017	2018
A	81 (no. of quotes), 19000 (units requested)	124, 45000
B	220, 44000	200, 10000
C	950, 78000	990, 55000
D	1330, 225300	1350, 344000

I want my chart to show the data for 2017 and display colored arrows depending on whether the product is growing or declining in 2018.

Is there any way to achieve this result? Also, I am open to suggestions for other chart types displaying the information in a similar fashion (something that gives you the information at a glance). Thank you!

2017

2018

Outcome desired

[Anonymous]

swuehl‌ stalwar1‌ gwassenaar‌ jagangmohan‌

[MarcoWedel · Accepted solution]

Hi,

maybe one solution might be:

hope this helps

regards

Marco

[Anonymous]

Thank you Marco!