Excel Add In

[narikisas]

Hi,

I have a stack of data which will be added every day. I had created a pivot out of it and need to present the data in a multiple graphs (one graph for each field) and would be requiring any one of your help in finding the VBA module/excel add in for achieving that.

Let me explain using a simple example.

I have the following data points in the columns

Date Name Metric1 Metric2 Metric3...

I need a way to present the data / find trends for each name for each metric reported in a better way. Say I should have option / drop down to select the name in one - The number of simultaneous days max up to 30 days in another - The same page should be having graphs for all the metrics.

So when a name is selected, number of simultaneous days is selected, the graphs should populate the respective agents/days data points automatically.

Attached example file for easy understanding.

Thanks

[dilipandey]

Hi narikisas,

See the attachment where I have used pivot slicers

Example.xlsx

Regards,
DILIPandey
<click on below * if this helps>

[narikisas]

Thanks Dilip. Pivot slicers did helped but I could not able to do it for multiple graphs using the same pivot. I tried with vlookup and could able to map date and metric with a drop down of names.