ranking highest selling to lowest selling via chart

Copper Contributor

Hi 

 

I'm trying to rank the highest selling items in an excel chart, basically I created a pivot table with chart that monitor based on monthly quarter with slider what is the highest stock but what I'm trying to do is monitor each stock of items and learn which is the fastest moving item for example an item that has 300 pieces in stock on each showroom sold within 1 month 250, that is a fast moving item, while an item with 300 pieces in stock sold 50 within 1 month is slow moving, my chart however is showing me the remaining stock on each show room with the highest number, i don't need that, what i need is to show the lowest number in comprising to previous stock within given timeframe so i can see what is selling faster

I'm open to suggestion.

 

 

thanks

1 Reply
Talk is cheap, now show us a sample data so we can help you