Pivot chart

[NAVEEN C N]

I have apread sheet which shows battery voltage by meter ID's from date range 1st sept to 4 th sept .

i want to create chart, that will shows meter id wise battery voltage( min battery voltage for the day)..

i thought of creating pivot chart, but it will pulls all the battery volatges of the day of the merter ( each meter id will have 4 to 5 bateery voltages in a day).. howver i need only the min battery voltage for the meter for the day..

please find attached spreadsheet for your reference..

Thanks on advance for your help...

 

[Faseeh]

Hi,

Pleaes see attached file i have added and helper column and then pivot chart.