| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I use Dynamic Ranges to automate complex calculations? | Excel Discussion (Misc queries) | |||
| automatically update pivot tables when dynamic named range is expa | Excel Discussion (Misc queries) | |||
| Complex Index Match Help (or at least complex to me) | Excel Discussion (Misc queries) | |||
| Dynamic update for graph data | Excel Worksheet Functions | |||
| Dynamic parameterized PivotTable update? | Excel Discussion (Misc queries) | |||
Threaded Mode
