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?
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?
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.
p45cal
Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.
Have you looked at Sparklines?
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'