Excel Forum



Excel Magic Trick 463: 4 ways to Add New Data To A Chart


See how to add data to a chart after the chart has already been created: 4 methods:
1) Copy data, click on chart, Paste
2) Click on chart, drag Range Finder edges
3) Copy data, click on chart, Paste Special if you want more control
4) Edit SERIES function" SERIES(Name,X values, Y values, Plot Order)
Keyboard shortcut for default chart on sheet; Alt + F1
If chart is selected, arrow keys cycle through chart elements





Got a Question? Ask it Here in the Forum.