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.