They are commonly used in formulas like =SUM(First Quarter Sales), where the name "First Quarter Sales" refers to cells C5: F5, for example. Now, the name "First Quarter Sales" refers to cells C6: F6.
Now, what if we want to add a column to the right of the source range, so that our output in Power Point shows six columns instead of five?Then the charts don't resize in PPT when the links are updated.3 - If you do use the Chart sheet approach, make sure the option (Tools, Options, Chart, "Chart sizes with window frame" is NOT checked. 4 - Alright you say, but I got my data on the worksheet, the only way I can make sure the chart makes sense is when I see the chart next to the data (a someone valid argument).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).AKA: Everything You Were Afraid To Ask Brian Reilly About Excel Charts, But That's OK, 'Cause He's Gonna Tell You Anyway.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..Now use the chart from the chart sheet to copy and paste link into PPT.5 - What if you already have charts made and linked into Power Point?So make the chart on the chart sheet (didn't we just agree on that? Select the entire chart on the chart sheet and copy and paste it to the worksheet near the data range.Any changes made to the data will clearly reflect on the chart sheet chart and since the worksheet chart is linked to the chart sheet chart, that will also instantly update.