| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Automatically Adding Data to Charts
After I make a chart with existing data, how do I make it so everytime I update the spread sheet or add data to it, the smae data is automatically added to the chart without having to go back and choose chart source and add it that way. -- lhollen1 ------------------------------------------------------------------------ lhollen1's Profile: http://www.excelforum.com/member.php...o&userid=24136 View this thread: http://www.excelforum.com/showthread...hreadid=377748 |
|
#2
|
|||
|
|||
|
Take a look at Jon Peltier's Dynamic Chart link
http://www.peltiertech.com/Excel/Charts/Dynamics.html That should get you in the direction you want to go. "lhollen1" wrote: After I make a chart with existing data, how do I make it so everytime I update the spread sheet or add data to it, the smae data is automatically added to the chart without having to go back and choose chart source and add it that way. -- lhollen1 ------------------------------------------------------------------------ lhollen1's Profile: http://www.excelforum.com/member.php...o&userid=24136 View this thread: http://www.excelforum.com/showthread...hreadid=377748 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Removing blank rows in a worksheet | Excel Worksheet Functions | |||
| Sorting data automatically | Excel Worksheet Functions | |||
| Excel Charts - Data being Plotted beyond Primary X-Axis Scale | Charts and Charting in Excel | |||
| Adding more source data to existing scatter plot | Charts and Charting in Excel | |||
| I wish to automatically populate cells with list data when a item. | Excel Discussion (Misc queries) | |||
Hybrid Mode
