| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Automation of change of data range
It is too tedious to have to go in and manually type in the new cell
references to update charts weekly. Is there a way to automate the process? If I could simply reference the new dates or something with maybe a macro would help. I am not conversant in Visual Basic, but an quite skilled in Excel. Thanks, KIOhio |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Automation of change of data range
Update, I neglected to mention Excel 2007.
"KIOhio" wrote: It is too tedious to have to go in and manually type in the new cell references to update charts weekly. Is there a way to automate the process? If I could simply reference the new dates or something with maybe a macro would help. I am not conversant in Visual Basic, but an quite skilled in Excel. Thanks, KIOhio |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Automation of change of data range
HELLO--Anybody--I still need help, please.
"KIOhio" wrote: It is too tedious to have to go in and manually type in the new cell references to update charts weekly. Is there a way to automate the process? If I could simply reference the new dates or something with maybe a macro would help. I am not conversant in Visual Basic, but an quite skilled in Excel. Thanks, KIOhio |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Automation of change of data range
Hi,
Have read up on dynamic named ranges. http://peltiertech.com/Excel/Charts/Dynamics.html Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "KIOhio" wrote in message ... HELLO--Anybody--I still need help, please. "KIOhio" wrote: It is too tedious to have to go in and manually type in the new cell references to update charts weekly. Is there a way to automate the process? If I could simply reference the new dates or something with maybe a macro would help. I am not conversant in Visual Basic, but an quite skilled in Excel. Thanks, KIOhio |
|
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Automation of change of data range
Thanks so much. I am going to do some reading now. This looks like my answer.
Dan D. Brown "Andy Pope" wrote: Hi, Have read up on dynamic named ranges. http://peltiertech.com/Excel/Charts/Dynamics.html Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "KIOhio" wrote in message ... HELLO--Anybody--I still need help, please. "KIOhio" wrote: It is too tedious to have to go in and manually type in the new cell references to update charts weekly. Is there a way to automate the process? If I could simply reference the new dates or something with maybe a macro would help. I am not conversant in Visual Basic, but an quite skilled in Excel. Thanks, KIOhio |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ?-Change data series range as data is entered? | Charts and Charting in Excel | |||
| Data Automation Transfer | Excel Worksheet Functions | |||
| Change color of bar graph w/automation | Charts and Charting in Excel | |||
| How do I change a range name back to the underlying data range? | Excel Worksheet Functions | |||
| variable range automation | Charts and Charting in Excel | |||
Linear Mode
