I have 2 questions and really need your help
1.I have data sheet and chart sheet.I am not using pivot table.For each new
day I am adding one line for current day data to data sheet.I have around 60
charts.How can I get charts updated automatically.I am currently selecting
each chart and extend data for adding one more line everyday to those 60
plots.(right click -selecting data and one more row from table) and it takes
a lot of time.
2.Is there anyway to embed bubble (comment) data to specific date in axis.I
have comments in bubbles for each day but they are shifting when I put new
day's data.So I need to shift back them to the correct location(date)
everyday.

Thanks in advance!

--
KHAN