dynamic range and chart - big help!!

X

Xaraam

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?!
 
B

Bob Phillips

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top