I'm trying to make a bot plot but having some issue with Excel 2007....I think.
My spreadsheet looks like this:
1st Half 2nd Half
Min 50 94
Q1 67 98
Max 100 100
Q3 92.5 100
When I tried to make a "Stock open-high-low-close" chart, I get this message: "Information: To create this stock chart, arrange the data on your sheet in this order: opening price, high price, low price, closing price. Use dates or stock namges as labels."
I tried the other stock graphs and didn't work as well.
Thanks for your help, in advance.
My spreadsheet looks like this:
1st Half 2nd Half
Min 50 94
Q1 67 98
Max 100 100
Q3 92.5 100
When I tried to make a "Stock open-high-low-close" chart, I get this message: "Information: To create this stock chart, arrange the data on your sheet in this order: opening price, high price, low price, closing price. Use dates or stock namges as labels."
I tried the other stock graphs and didn't work as well.
Thanks for your help, in advance.
