If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Chart adjustable range
Is there any way to incorporate an OFFSET function or a named range into an
Excel chart so that the chart series' reference an automatically adjustable range of cells? Charts are generically set up to reference a fixed range, such that if you add an additional row to the end of the series you must manually adjust the chart to capture the new row. In my example the beginning of the data series is fixed at a beginning date and new rows of information are periodically added as time passes. Being able to have the chart automatically reflect this rather than manually adjusting the chart would be a big time saver. Thanks, |
#2
|
|||
|
|||
Chart adjustable range
Hi,
Yes. Have a read of Jon's blog, which includes links for more information. http://peltiertech.com/WordPress/200...ynamic-charts/ Cheers Andy iperlovsky wrote: Is there any way to incorporate an OFFSET function or a named range into an Excel chart so that the chart series' reference an automatically adjustable range of cells? Charts are generically set up to reference a fixed range, such that if you add an additional row to the end of the series you must manually adjust the chart to capture the new row. In my example the beginning of the data series is fixed at a beginning date and new rows of information are periodically added as time passes. Being able to have the chart automatically reflect this rather than manually adjusting the chart would be a big time saver. Thanks, -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#3
|
|||
|
|||
Chart adjustable range
Very helpful. Thanks.
"Andy Pope" wrote: Hi, Yes. Have a read of Jon's blog, which includes links for more information. http://peltiertech.com/WordPress/200...ynamic-charts/ Cheers Andy iperlovsky wrote: Is there any way to incorporate an OFFSET function or a named range into an Excel chart so that the chart series' reference an automatically adjustable range of cells? Charts are generically set up to reference a fixed range, such that if you add an additional row to the end of the series you must manually adjust the chart to capture the new row. In my example the beginning of the data series is fixed at a beginning date and new rows of information are periodically added as time passes. Being able to have the chart automatically reflect this rather than manually adjusting the chart would be a big time saver. Thanks, -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Thread Tools | |
Display Modes | |
|
|