How can update the data in a chart on excel | Excel forum

Dear Richard,

Thank you for your question in STL's forum.

Charts should automatically update to show the latest data if the data in the underlying data source changes. However, I assume that you want to know how to add additional data to your chart.

To update the chart with newly provided data is first to select the chart on the sheet. You shoud find an additional tab added t the ribbon with Chart tools. Depending on the version of Excel the Chart Tools tab may differ slightly, but amongst the tools you should find a button that says: "Select Data" or "Edit data".
When you click that button it shoud take you to the source data for your chart. All you need to do is use your mouse to select whatever data you wish to see in your chart to replace the existing range in the box after "Chart Data Range" with your new range and click OK. Your chart should now display the new data.

I hope this answer is what you were looking for.

If you have any further questions or remarks then please reply to this message

Kind regards

Ron Oldeboom
Learning and Development Consultant at STL