Forum Discussion
Scatter plot showing growth/decline
Hi winnston84 ,
I am not clear about your data structure, I don't know the feature of last several columns, if possible, could you please explain it to me in details. In addition, I use first 5 columns to create a report, you could refer to my sample for details.
Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi winnston84 ,
I am not clear about your requirement, if possible could you please inform me more detailed information(such as your expected output and your sample data (by OneDrive for Business))? Then I will help you more correctly.
Please do mask sensitive data before uploading.
Thanks for your understanding and support.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
https://drive.google.com/open?id=1VQLviaaKEmLFcnWRmSvi8p0u_QRsMNqG
So i believe this is the calculation i am trying to achieve, the final column being the growth/decline of products over 5 years. From this I would hope would achieve a plot something like this:
https://drive.google.com/open?id=1h86ccJC9TF6SrfxBloTo426nXeev-Qjp
Fundamentally, i want a nice clear way to show which products are in growth and which ones are in decline.
Hi winnston84 ,
I am not clear about your data structure, I don't know the feature of last several columns, if possible, could you please explain it to me in details. In addition, I use first 5 columns to create a report, you could refer to my sample for details.
Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.