PDA

View Full Version : Making graphs in loop



zhangc13
06-23-2010, 10:08 AM
basically I have 500 rows of stock data, 12 columns each. I want to make 500 individual line graphs, one for each row of data.

how do I go about doing this?

p45cal
06-23-2010, 10:57 PM
Especially if you haven't moved to Excel2007 or later yet; to get started, record a macro where you creat just 2 such line graphs and post the resultant code here.

mdmackillop
06-24-2010, 12:16 AM
Have you looked at Sparklines (http://sparklines-excel.blogspot.com/)?