|
Featured Tutorial
Featured Macro
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
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