Now, stay with this one, it splits into two thoughts now.
a) if the "upper left hand corner of the chart is not visible" in what would be the Active Window of the spreadsheet (if it were open), the update linker won't see it and may not update the chart, or worse, may chop off part off the chart image. b) the second issue is the Active Window zoom factor, if you are really going to insist on putting charts on worksheets (more on that later).
Good question, and I wondered if he’d encountered some unexpected problem, perhaps a bug, in Mac Excel. Bottom line: There are several ways to make dynamic charts in Excel, and there seems to be no difference other than cosmetic in how they work between different versions of Excel, and between operating system.
The protocols are the same for Mac Excel and Windows Excel, and perhaps it’s time for a quick review.
Not only is that time you don’t have, but it could lead to errors, which would be embarrassing.
So you want to link the table or graph in Excel to your Power Point slide.
Then when the numbers change next week or month, the Power Point slide can automatically update. Except every great idea does have potential downsides you need to know about.
Here’s what you need to consider before deciding to link a table or graph from Excel to Power Point: If you still want to link the cells from Excel to the slide in Power Point, scroll down to see how to do it.
Actually, much of the content here originally was contributed to Brian by Naresh Nichani, an Access MVP, who is the real code writer behind Brian..
If you’re simply looking for where you define or modify named ranges in Excel 2010 (as one commenter indicated in response to an earlier version of this update), it’s on the Formulas tab in the Defined Names area — Name Manager.
If you are looking for other Excel 2010-specific information that this post doesn’t cover, please leave a quick comment as to what the change/issue is that led you to the search.
If you want to advance beyond your ordinary spreadsheet skills, creating dynamic charts is a good place to begin that journey.
The key is to define the chart's source data as a dynamic range.