How to create Graphic with variable data (filtered)

Copper Contributor

Hi everybody,

 

I have an excel spreadsheet with all the sales forecast of 160 products. I have the quantity sold for each product every month for the last 5 years. 

 

With graphics, I can see the sales forecast for each product. However, doing 160 graphics is too much for the Excel spreadsheet.

 

Therefore, I was wondering how to create just one graphic and by having a filter (with search bar for instance), I can select the product I want to see the trend and the graphic automatically just display the sales of this product? 

 

How do to that?

 

Thank you so much for your help!

1 Reply
You could create a pivot table with product as the page filter field and which then contains the data you want charted. Then create a pivot chart from that pivot table. you can now choose the product using the page field filter.