Dynamic Charting with Excel 2010

[sdharmarajan]

I have two columns of data which are used to make column chart. How do I update the chart as I add more data to previous column and row. Thanks. sdharmarajan

[MarvinP]

Hi sdharmarajan and welcome tot he forum.

I believe you want to learn about Dynamic Named Ranges (DNR) and base your chart on the name instead of a fixed range.
See
http://www.beyondtechnology.com/geeks007.shtml or
http://www.contextures.com/xlNames01.html or
http://www.ozgrid.com/Excel/DynamicRanges.htm