Excel Macros to repeatedly graph price charts

TZANKOVC · May 16th, 2002, 07:39 AM

This should be a simple task, yet it seems rather elusive for someone like me, who is not familar with Visual Basics programming.
I have many (over 200) sets of two columns, listed next to each other, in Excel -the first column lists dates and the second prices for a given security on each respective date. I would like to create a simple price chart for EACH security on a SEPARATE graph (and position it below the respective set of data). I tried recording a macro using relative references, graphing the first set and hoping, that once I run the macro , excel will graph the next set and so on. Alas, it did not work. What can i do to accomplish this task? Please explain like you would to somoene who has NO programming background whatsoever. Thanks!!!

Chris

cornbread · May 16th, 2002, 03:18 PM

I have plenty of programming experience but no graphing experience with excel. check your private messages and e-mail the sheet to that e-mail address and I will see what I can make it do for you. It may take me a bit of time to get back to you. Like a day or so as I am swamped right now but it doesn't sound to difficult.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 16th, 2002, 07:39 AM	#1
TZANKOVC New Member Join Date: May 2002 Posts: 1	This should be a simple task, yet it seems rather elusive for someone like me, who is not familar with Visual Basics programming. I have many (over 200) sets of two columns, listed next to each other, in Excel -the first column lists dates and the second prices for a given security on each respective date. I would like to create a simple price chart for EACH security on a SEPARATE graph (and position it below the respective set of data). I tried recording a macro using relative references, graphing the first set and hoping, that once I run the macro , excel will graph the next set and so on. Alas, it did not work. What can i do to accomplish this task? Please explain like you would to somoene who has NO programming background whatsoever. Thanks!!! Chris

May 16th, 2002, 03:18 PM	#2
cornbread Board Regular Join Date: Apr 2002 Location: Oregon Posts: 77	I have plenty of programming experience but no graphing experience with excel. check your private messages and e-mail the sheet to that e-mail address and I will see what I can make it do for you. It may take me a bit of time to get back to you. Like a day or so as I am swamped right now but it doesn't sound to difficult.