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.