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.
But once you’ve created a chart, it keeps plotting data from the same cells.
If the data in the cells changes, so does the chart, but if the data extends to more cells (or shrinks to fewer cells), the chart doesn’t seem to notice.
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.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.There are a couple ways to create charts that will grow with your data.The easiest way is to use Tables as the chart source data.