LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
automatically move data to another file reza Excel Discussion (Misc queries) 1 October 7th 09 01:34 PM
Automatically move data from one worksheet to another CdnBlueEyes Excel Discussion (Misc queries) 2 August 14th 09 10:50 PM
How to move data from one sheet to another automatically Harleyrider888 Charts and Charting in Excel 1 July 11th 09 02:52 AM
move data in cells automatically Ann Excel Worksheet Functions 1 June 5th 08 03:43 PM
how do i automatically move data from rows to columns? iainmac Excel Discussion (Misc queries) 1 April 16th 07 03:16 PM


All times are GMT +1. The time now is 11:06 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"