Adding Data to a Chart in Excel

Want to add more data to an existing chart? Check that your new data is the same size and shape as either a row or column of the existing data (including the heading) - it doesn't have to be on the same sheet as the Chart or the rest of the data. Then just Copy the data, click on the Chart to activate it and click Paste.