The chart on the new worksheet updates as soon as the new data is pasted into place. Paste the new data over the old data on the copied worksheet.Make a copy of the worksheet with the old data and chart.But the article above describes an easier way: Copying and pasting the chart onto the new sheet requires you to change links in the chart, usually series by series. Most commonly you have a worksheet with a bunch of data and a corresponding chart, and you have another sheet of data you want to add a chart to. I described a few ways to handle this in Make a Copied Chart Link to New Data. A very common task you may have is to take a chart you’ve painstakingly formatted and use it with new data.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |