Ken - thanks for the note on the bars, I was able to figure it out as well. Guess if you mess around enough, you get to know the ins and outs as well.....or some of them.
Well thanks to your help, I have made significant progress with the chart and have attached it as a pic below. As I continue to see the chart develop, I am starting to better determine which direction I would like to take the chart, and this is where I will need your help. Listed below are my challenges and am requesting if you can help me out here:
1. Can I separate/partition the chart by quarters? So instead of seeing 1 complete chart, there will be 5 broken sections (Q4-2010 - Q4-2011) with the price line at the top and volume bars at the bottom...as I already have it. This will help indicate the quarterly movement for the past few quarters. If that is too challenging, can we have the chart self-generate a vertical line (maybe in red) separating the quarters, instead of using the picture object or something and doing it manually?
2. Considering we can do one of the items mentioned in #1 above, I would like to show the quarterly change as a $$ and % change. I am assuming a text box can do this, but I am also assuming I will have to shift the text box as I continue to add more stock price information. Can we have the chart self-generate this information, instead of having to shift the 5 text boxes (1 for each quarter) every time I add more data?
3. "I believe" the volume bars that are in the chart show the actual stock information (even though it is only volume), because the volume bars represent information for the days the stock actually traded. There are no volume bars for weekends or holidays, however, the stock price line on the top of the chart seems to be running continuously from start to finish. Is there a way I can fill in the gaps for the volume bars.....I tried to make the lines thicker, but will that fill in all the gaps? Sounds odd to ask for this fix, considering the volume information is accurate.
4. Considering I separated the x-axis data by 3-months, why doesn't Dec 2011 show at the far right of the x-axis?
This is all I have for now and I hope my comments or questions have not confused you. If you have any questions, please feel free to ask and feel free to respond when time permits. I do not want to trouble you with my excel questions.
But most importantly, I appreciate all your help.
Thanks.