hydeparker
New Member
- Joined
- Jun 5, 2009
- Messages
- 1
In chapter 7 of John Walkenbach's 'Excel Charts' book from 2003, he has a section on creating a dynamic chart where the series plotted depends on the location of the Active Cell in the worksheet.
In the new edition of this book, 'Excel 2007 Charts', his Table of Contents is very similar, but this section of chapter 7 is omitted.
Sure enough, I'm not able to replicate the chart in Excel 2007.
To create the chart in Excel 2003, you define a named range, such as:
rngDynamic = Offset($A1,0,0,1,10)
Notice that the row in the $A1 reference is relative. This'll make rngDynamicRange depend on what row is active in the worksheet. Then, you set the Source Data for a chart series to =Sheet1!rngDynamic and voila... now your charted series will change when you move around in the workbook.
What I cannot figure out is how to get a chart in Excel 2007 to take on this dynamic range as a source and actually re-calculate the Offset() (either via VBA or pressing F9) the way it did in Excel 2003.
Anyone have any ideas on how to accomplish this?
In the new edition of this book, 'Excel 2007 Charts', his Table of Contents is very similar, but this section of chapter 7 is omitted.
Sure enough, I'm not able to replicate the chart in Excel 2007.
To create the chart in Excel 2003, you define a named range, such as:
rngDynamic = Offset($A1,0,0,1,10)
Notice that the row in the $A1 reference is relative. This'll make rngDynamicRange depend on what row is active in the worksheet. Then, you set the Source Data for a chart series to =Sheet1!rngDynamic and voila... now your charted series will change when you move around in the workbook.
What I cannot figure out is how to get a chart in Excel 2007 to take on this dynamic range as a source and actually re-calculate the Offset() (either via VBA or pressing F9) the way it did in Excel 2003.
Anyone have any ideas on how to accomplish this?