Hey everyone!
I have a (rather simple & dumb) problem that I've been trying to solve for the last 2 hours...(attached is an excel).
I have created a simple scatter plot - on X axis are the number of polices; on Y axis is the average maturity => and represented inside the scatter plot are the total savings over the average maturity. As a filter/slicer I have the Cost reduction per policy in EUR and year (basically I only want the chart to show me values if the values from this slicer are selected).
For some reason I think I messed up and did not create the chart properly - for example the rightmost scatter plot circle when "-30" is in the slicer represents the total savings of -€ 225,000,000 , but why is it shown near the average maturity of 2-3 (compared to Y axis) when it's average maturity is in fact 15??
I would really appreciate if someone could tell me what I did wrong and how is it fixable.
Also if you think there is any better (simpler) way of plotting this instead of a scatter plot, please let me know .
Bookmarks