Forum Discussion

winnston84's avatar
winnston84
Regular Visitor
6 years ago
Solved

Scatter plot showing growth/decline

HI,   I'm looking for some help to show the growth/decline in products (i.e. Phones, Laptops, Tablets, Desktop PC) between years e.g. 2013-2018. Essentially i am wanting a scatter graph showing:  ...
Need Help
  • dax's avatar
    dax
    6 years ago

    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 Zhi

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

dax's avatar
dax
Community Support
6 years ago

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.

winnston84's avatar
winnston84
Regular Visitor
6 years ago

Well the bit im struggling with is how to calculate the actual measure of if a product category is in growth or decline.

 

Between two years, i have found the calculation for that. However across say 5 years, i am not sure what the calculation is. I believe there is an excel formula called "LINEST" which will do it and provide a final 'score' which will be positive or negative - growth or decline.