(This approach only works if the chart is on object on the same worksheet that contains the data on which the chart is based.) Follow these steps: That's it—Excel incorporates the new data right into the existing chart, slick as a whistle.
Another approach is to add new data to the range not at the end, but somewhere within the range.
If you want to support the CAD Forum web service, consider buying one of our CAD applications, or our custom software development offerings, or donating via Pay Pal (see above).
This can be painful when you always want, or don't want, links updated.
Lot's More: Excel Macros Update Links in Excel When you have formula links in an Excel Workbook (destination) to another Excel Workbook (source) you will be asked if you wish to update links in the Workbook (destination) each time you open it.
For example, noon (halfway through the day) is represented as 0.5.
Excel shines at turning your data into charts—graphical representations of your data.