Dynamic Update - Complex
I have a data set that looks like this:
http://i2.photobucket.com/albums/y4/...r/Untitled.jpg I have been creating 2 charts, 1 from the amount column and 1 from the mid price column which looks like this:http://i2.photobucket.com/albums/y4/...Untitled-1.jpg How do I make the charts update automatically? I can follow the examples for a single column of data that updates the chart when a new row is added but I am adding 4 columns at a time and using the data in every fourth column and I cant work out how to do it. |
Dynamic Update - Complex
Thank you very much John
|
All times are GMT +1. The time now is 11:49 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com