McBeginner
New Member
- Joined
- Jun 25, 2009
- Messages
- 1
Dear users,
This is one of my first steps into the magnificient world of visual basic for applications, i hope someone outthere is willing to help me. I looked on several forums, but most of the time the questions asked are much more complex than mine.
I am looking for a piece of code for the preparation of multiple charts in excel 2003. I am sure this can be of assistance to many beginners like me.
The data is as follows:
x-axis is in the first column (A)
y-axis data are in columns B to ...
I'd like to prepare charts containing the data from 3 series e.g. i) columns B:D, E:G, H:J, etc.. A graphs with three lines.
The number of graphs that i'd like to prepare is e.g. 20 graphs with each 3 lines. However, it could be that more or less data is generated, so i think this requires the use of loops.
The generated graphs (if possible) should be put in a matrix of 10 (columns) x 2 (rows)
Even better would be if a pop-up box asks how the graphs should be aligned (e.g. 4 columns by 5 rows)
The three lines should be in "red", "blue" and "green", the y-axis should depend on the intensity of the data for each graph.
The legend should be included (titles of each columns).
Computer system used: Windows XP, Excel 2003.
I really hope someone could help me with some piece of code, it would fasten the data analysis enormously, since now all figures are done by hand in changing the source code of the graphs.
kind regards, McBeginner
This is one of my first steps into the magnificient world of visual basic for applications, i hope someone outthere is willing to help me. I looked on several forums, but most of the time the questions asked are much more complex than mine.
I am looking for a piece of code for the preparation of multiple charts in excel 2003. I am sure this can be of assistance to many beginners like me.
The data is as follows:
x-axis is in the first column (A)
y-axis data are in columns B to ...
I'd like to prepare charts containing the data from 3 series e.g. i) columns B:D, E:G, H:J, etc.. A graphs with three lines.
The number of graphs that i'd like to prepare is e.g. 20 graphs with each 3 lines. However, it could be that more or less data is generated, so i think this requires the use of loops.
The generated graphs (if possible) should be put in a matrix of 10 (columns) x 2 (rows)
Even better would be if a pop-up box asks how the graphs should be aligned (e.g. 4 columns by 5 rows)
The three lines should be in "red", "blue" and "green", the y-axis should depend on the intensity of the data for each graph.
The legend should be included (titles of each columns).
Computer system used: Windows XP, Excel 2003.
I really hope someone could help me with some piece of code, it would fasten the data analysis enormously, since now all figures are done by hand in changing the source code of the graphs.
kind regards, McBeginner
