OK….your explanations make sense. As for working in excel there are tons of things you could do. Excel happens to be one of the most powerful computer software programs ever and actually has other software embedded in it that most people don’t know about (but that’s another subject and another messageboard all together!). The simplest way to make your graph look nice is to use the draw tools. To do this make sure you have the draw toolbar open. From here you can use the tools to actually draw lines, dots, triangles, whatever on your worksheet. If you want to get a little more complex, you could actually turn your “BIMOTOR ELEMENTS”; “SPEED ELEMENTS”; “VOLUME”; and “INTENSITY” into data sets rather than just writing in numerals or astericks in the cell spaces. If you did this you could then graph the above mentioned parameters and get a graphic representation of what is going I find this kind of thing much easier to see what is actually going on ( a picture tells a thousand words). Once you learn to do this kind of thing it makes creating charts like yours very simple. I’ve attached a picture of a graph using some of the data from your excel file. It only took me about 2 minutes and you could easily do the whole macro in this format.
ELITETRACK Founder