Error in Creating chart from data in Excel

C

Curious

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?
 
C

Castell

The Date column needs to be the first column, followed by the High, Low &
Close columns.
 
C

Curious

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top