Fixing Cart Data Range

[Po547]

I have chart data that is in columns. To add new data I insert a row a
the top of the data range. When I do so, the chart data range does no
pick up the new row, it actually moves down with the original top row.
I have to manually move the data range up to include the new row. Ho
can I I make the chart data range fixed so it automatically picks u
the new top row and dorps the old bottom row.

Thanks for your help

 

[Frank Kabel]

Hi
one way:
define a name (goto 'Insert - Name - Define Name'). e.g. the name:
chart_range:
=INDIREKT("A1:A10")
to chart the first 10 rows of column A and use this name in your chart
as data source. For using defined names in charts see
http://www.tushar-mehta.com/excel/newsgroups/dynamic_charts/names_in_ch
arts.html
http://www.tushar-mehta.com/excel/newsgroups/dynamic_charts/named_formu
las.html
http://peltiertech.com/Excel/Charts/DynamicColumnChart1.html

HTH
Frank

 

[Po547]

Thanks for the help.
Appeciate it