want to make dynamic chart

Hi

I wish to make dynamic chart of attached file, in same sheet.something like dashboard

AttachmentSize
Book1.xls18.5 KB
Almir's picture

It depends on what you want

What would you like to show by dashboard. I suggest creating COUNTIF and SUMIF formula. Try to use Data Validation list containing "Apparel" and "Home Décor" as criteria for COUNTIF and SUMIF. Chart should reflect selected data. Something like that?