hey!!

i'm working now with dynamic range for single column and charts.
i've a chart with number on the y axis and dates on the x axis and i would
like to make a chart in which every time a new number and date is added to
the sheet, the chart automatically updates.
I've tried using dynamic ranges with the offset function, like this:
OFFSET($A$1,0,0,COUNT($A:$A),1)

however every time new values are added, i necessarily have to make a new
chart.

can someone give me some hints?!

You need to have a dynamic range for every series on the chart, and one for
the labels.

--
__________________________________
HTH

Bob

"Xaraam" wrote in message
...
hey!!

i'm working now with dynamic range for single column and charts.
i've a chart with number on the y axis and dates on the x axis and i would
like to make a chart in which every time a new number and date is added to
the sheet, the chart automatically updates.
I've tried using dynamic ranges with the offset function, like this:
OFFSET($A$1,0,0,COUNT($A:$A),1)

however every time new values are added, i necessarily have to make a new
chart.

can someone give me some hints?!

Hi Xaraam
See if the article at
http://peltiertech.com/Excel/Charts/...html#DynColCht
does what you want.

Regards,
Pedro J.

hey!!

i'm working now with dynamic range for single column and charts.
i've a chart with number on the y axis and dates on the x axis and i would
like to make a chart in which every time a new number and date is added to
the sheet, the chart automatically updates.
I've tried using dynamic ranges with the offset function, like this:
OFFSET($A$1,0,0,COUNT($A:$A),1)

however every time new values are added, i necessarily have to make a new
chart.

can someone give me some hints?!

yeaph!!..terrific!..thanks!!

"Infinitogool" wrote:

Hi Xaraam
See if the article at
http://peltiertech.com/Excel/Charts/...html#DynColCht
does what you want.

Regards,
Pedro J.

hey!!

i'm working now with dynamic range for single column and charts.
i've a chart with number on the y axis and dates on the x axis and i would
like to make a chart in which every time a new number and date is added to
the sheet, the chart automatically updates.
I've tried using dynamic ranges with the offset function, like this:
OFFSET($A$1,0,0,COUNT($A:$A),1)

however every time new values are added, i necessarily have to make a new
chart.

can someone give me some hints?!