How Can I Make My XLS Chart Update Automatically When Adding New Data?

tanand79
Hi, I have two columns in my XLS file and I want the chart to update automatically with the insertion of values into those columns. Can someone please help? Please find attached the XLS sheet.

Thanks
1 Attachment(s) [Login To View]

tanand79
Thanks a lot, rajkp4u. Awesome, it works. However, I am not able to include the titles of the columns in this chart. It just shows as 1 & 2 in the charts. Is there any way we can display the column titles?
anoopbhagat7
Just double-click on the chart where it shows 1 and 2, and manually edit the values.
If you are knowledgeable about any fact, resource or experience related to this topic - please add your views. For articles and copyrighted material please only cite the original source link. Each contribution will make this page a resource useful for everyone. Join To Contribute