Hi.

I have download some USD/JPY currency and i want to have them in a daily candlestick chart.
It's a long file. The date of begining is form 2002-06-25 untill now.

But when i gonna create a candlestick chart, it's says to me that i need to have opening;High;Low;Close in order. But i don't have it in order. The close-data is opeing data for the next day. At first we must "ignore" the opening data for the first row.

Can you help me?
I upload the file. The file is a csv file. exchange_USDJPY.csv
http://uppit.com/aaywk9d41ut8/exchange_USDJPY.csv

By the way. I don't know if it's possible to make a daily chart of candlestick but i hope that Excel have a function who can stroll back to the past of the data. Trying to fitt data from 2002 and 2012 on a pece of paper won't work.