Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
update graphs automatically either from same book or a new spreads
Hi and thank you in advance for your help.
I have a spreadsheet called Data Status. It is updated daily, throughout the day with many fields of information. I have created a seperate spreadsheet where I keep a summary of this data. I call this my graphing spreadsheet. So once a week I copy and paste a summary (that I created on data status) to my graph spreadsheet. On the second and third tab of the graph sheet I have many graphs which get their data from the first tab. When I update the graphs I have to go into each one every time and change the ranges. (The summary data I add is on a new row everytime so i have to change the date range and information range, bearing in mind i have over 30 graphs many with 4 or more fields) Is there a way that these graphs can either be updated from the original data status (bearing in mind that it is saved as a new version everyday) or a way that when I just copy and paste the new data into the graph spreadsheet that it just updates the graphs? I am not very good with macros and other 'fancy advanced' uses of excel. However I can use most of the formulas. Please be gentle with your advice! And thank you in advance again! Helen |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
update graphs automatically either from same book or a new spreads
Create Dynamic Ranges for your graph data sources.
These will expand/contract to fit the source ranges. See Stephen Bullen's site to download a sample workbook that shows you how. http://www.oaltd.co.uk/Excel/Default.htm Scroll down to FunChrt1.zip and download the workbook. Gord Dibben MS Excel MVP On Tue, 4 Aug 2009 02:16:01 -0700, Helenf wrote: Hi and thank you in advance for your help. I have a spreadsheet called Data Status. It is updated daily, throughout the day with many fields of information. I have created a seperate spreadsheet where I keep a summary of this data. I call this my graphing spreadsheet. So once a week I copy and paste a summary (that I created on data status) to my graph spreadsheet. On the second and third tab of the graph sheet I have many graphs which get their data from the first tab. When I update the graphs I have to go into each one every time and change the ranges. (The summary data I add is on a new row everytime so i have to change the date range and information range, bearing in mind i have over 30 graphs many with 4 or more fields) Is there a way that these graphs can either be updated from the original data status (bearing in mind that it is saved as a new version everyday) or a way that when I just copy and paste the new data into the graph spreadsheet that it just updates the graphs? I am not very good with macros and other 'fancy advanced' uses of excel. However I can use most of the formulas. Please be gentle with your advice! And thank you in advance again! Helen |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Update one worksheet tab to automatically update all other tabs? | Excel Worksheet Functions | |||
Automatically update graphs | Charts and Charting in Excel | |||
How do I update graphs automatically with periodic data updates | Charts and Charting in Excel | |||
excel graphs won't update | Charts and Charting in Excel | |||
update multiple worksheet in single book | Excel Worksheet Functions |