I want to create a chart containing high price, low price, and closing
price for each day. Therefore, I have these three columns in my Excel
sheet plus an extra "date" column.
I want to use "data" as label in X direction, and use "high price",
"low price", and "closing price" in Y direction.
However, there's an error when I create a chart to intuitively display
the data:
"To create this stock chart, arrange the data on your sheet in this
order: high price, low price, closing price. Use dates or stock names
as labels."
Anyone could tell me what is wrong and how to get this error fixed?
Castell - 07 Apr 2008 21:32 GMT
The Date column needs to be the first column, followed by the High, Low &
Close columns.
>I want to create a chart containing high price, low price, and closing
> price for each day. Therefore, I have these three columns in my Excel
[quoted text clipped - 11 lines]
>
> Anyone could tell me what is wrong and how to get this error fixed?
Curious - 08 Apr 2008 22:16 GMT
But I got the error:
"To create this stock chart, arrange the data on your sheet in this
order: high price, low price, closing price. Use dates or stock names
as labels."
How shall I get this error fixed?
FYI, I did have four columns, date, high price, low price, and closing
price.