Good Afternoon Everyone,
I have a list that contains our companies purchase order details (i.e PO#, Date, Vendor, Amount, etc.). I would like to have a bar/column chart that will show the count of Purchase Orders created for our top 5 vendors. I would like this chart to dynamically update the vendors, not hard code them. For instance if a large PO is written for the 6th largest vendor and they surpass the 5th, I would like the chart to reflect so without the need to alter anything on the chart. Is this possible?
Thanks for any help/suggestions.