Forum Discussion
How to create Graphic with variable data (filtered)
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 th...
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.