Answer - Large Amount of Data Into Charts with Options to Filter

To apply the pivot chart, please select a single cell within your source data then follow the instruction below.

Insert > Table > Pivot Table > Pivot Chart

Hope it helps,

Raymond

AttachmentSize
Pivota Chart (RReyes).xlsx20.22 KB