Dynamic Chart

[NAVEEN C N]

Hi,

I need to prepare dynamic chart for the attached report...

Need a drop down list for Meter ID.. When i select each meter ID, it should displays line graph for battery voltage, core voltage, reference voltage and the temperature in separate graphs..

Time will be x-axis and voltages will be on y-axis... When we add the data on daily basis, the graph should update with the new data...

Await your response...

Thanks in advance for your help..

Regards,
Naveen C N

 

[Hui]

Which Time column on X Axis ?

 

[NAVEEN C N]

Diag time in Column D..

 

[Somendra Misra]

Hi Naveen,

See your file. Sheet2.

Regards,

 

[NAVEEN C N]

Thanks a lot Hui for your quick response and superb charts...

 

[Somendra Misra]

@NAVEEN C N

You are welcome

Regards,

 

[Hui]

Naveen,

It was Somendra who answered your question

 

[NAVEEN C N]

Hi Hui,

I have added to some more data for the main sheet, what changes should i do to reflect the data in charts...

Await your response...

 

[Somendra Misra]

@NAVEEN C N

In you sample file, I had converted your raw data to Table, so if you add data just below it, Table will expand, try to do it and Just see if you get more more Meter Id and accordingly data for chart changes or not.

Regards,