Automatic Updating Of The Chart In The Xls Sheet Download

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

Check now. I feel this should work.

---

Check now. I feel this should work.

Thanks a lot, rajkp4u. Awesome, it works. But I am not able to take the titles of the columns into this chart. It just shows as 1 & 2 in the charts. Is there any way we can show that?

Thank you for your kind work!

I understand that Excel can handle only seven conditional formulas in a single cell. In order to add more than seven conditional formulas, you need to arrange the formulas differently. Can you please help me with how to do that?

I hope to receive a reply soon.

Dear Anand,

Just double-click on the chart where it shows 1 and 2, and manually edit the values.