Please can anyone help?
I have a series of products..each week I see the percentage of total sales and their rank in the top ten.
So the data looks like this
Week1 | Product 1| % |rank
Week1 | Product 2 | % |rank
Week2 | Product1 | % |rank
Week2 | Product2 | % |rank
Etc for ten products
I need to track 1) the sales percentage over time and 2) the rank over time
I can then annotate the chart to show why it may have dropped.
But I can't seem to get the data to pull properly on the charts..it may require pivot tables? (Which I have briefly worked with but let's assume I haven't!)
Help!
Sorry if the format doesn't work, on my phone!
I would be forever grateful for your help!
Also,.if I need to enter the data in another way then I can also do that!
Edited for spelling