could never get the info to xfer over
In Excel, if you are referring to the updated data cells being reflected in the chart, I find the best thing to do after inserting a chart (or more data) is this:
- Right click on the chart
- Select “Source Data”
- Select the “Series” tab in the pop up
- For the X data, change the last cell number in the selected data to be way beyond the number currently selected (which, when creating the chart, is the last data point)
- Do the same as above for each series of Y data
Assuming this or something close works for different versions of Excel. If I misunderstood, then apologies for wasting your time