View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
msdnquestion msdnquestion is offline
external usenet poster
 
Posts: 4
Default Macro to automatically move chart data

Hi Everyone
I am trying to automate a excel spreadsheet with a chart. There is one
table with the week and data fields. The chart shows data for the last ten
weeks. Every week a new line is added to the data table at the bottom with
the new week and new data. Right now I have to click on the chart and then
move the selection in the data part one line down to include the new data. Is
there a way to automate this.
Thank You