74. Excel Tips - Dynamic Charting

When you add a chart, it's not obvious at all how to construct it so that new additions to your data are automatically added to your graph
- Fortunately, help is at hand with dynamic ranges
- A Dynamic range is one that changes depending on the data
- When you add data at the bottom in this example, the range size increases by 1 row
Here's a screen shot of our data in Excel:
Here's how to add a dynamic range:
- Add a range name as shown:
- In the source data for your chart, enter the source as shown:
- Note the exact format of that: =' workbookname .xls'! RangeName
Download sheet to practise how to Dynamic Charting in Excel
Training Video on how to Dynamic Charting in Excel:
Attachment | Size |
---|---|
dynamic-charting.xls | 34 KB |
»
- Nick's blog
- Login or register to post comments
- 9520 reads
Recent comments
5 years 50 weeks ago
6 years 36 weeks ago
6 years 47 weeks ago
6 years 50 weeks ago
6 years 51 weeks ago
7 years 5 weeks ago
7 years 13 weeks ago
7 years 13 weeks ago
7 years 13 weeks ago
7 years 13 weeks ago