• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Dynamic chart

NAVEEN C N

New Member
HI,

I need a chart showing date on x axis and battery voltage on y-axis..

We have around 130 meter IDs.. as and when i chnages the meter ids, chart will also should chnage ( dynamic chart).

Please find attached report for you kind reference..

Thanks in advance for your help..
 

Attachments

  • Chandoo.xlsx
    23.6 KB · Views: 4
Thanks Hui..

Yes i forgot, we can use pivot chart but if we want to add some more dates data.. how the pivot chart will be updated..

Please explain..
 
Use a named formula for the data source for the pivot table rather than a fixed range

I have setup a Named Formula called "d"
It has the formula =Offset($A$1,,,Counta($A:$A),3)

If you add/delete or change data to the table
Simply right click on the PT and select Refresh

See attached
 

Attachments

  • Chandoo-Hui2.xlsx
    39.5 KB · Views: 12
Back
Top