Excel Table to charts for all combinations
Hi Nick,
I am trying to chart the expiration day behaviour of Stock price Vs Straddle Cost. I am collecting all the deatils in Access and getting that data in excel. I have attached the table image and one chart image.
This table has periodic data for a few tickers and a few strike prices for each ticker. I filter on the table's tocker and strike price (AAPL, 140-Strike in this example) and get the chart. There are about 20 Tikcer-StrikePrice combinations.
I would like to automatically draw 20 charts for each of the combinations. (Right now, I filter on the table and see the chart on the right)
How can I do this?
Thanks,
Laks
Chart (for one Combo):
| Attachment | Size |
|---|---|
| Laks-6-19-2009-0001.png | 28.03 KB |
| Laks-6-19-2009-0000.png | 29.78 KB |
charting
Hi Laks
the way I'd go about this would be to link a pivot table to the data with 20 specific views on 20 sheets, then create pivot charts... you can position these on one sheet... or add a button to create the charts using VBA.
e.g: Create A Chart