How can I flip the whole chart horizontally?

[evanesce]

Hi.

I have a chart that looks like below.

It is the price of Samsung Electronics, inc with loan transaction.

The blue one is the change of the stock price and the orange one is loan transaction.

I want to flip the whole graph horizontally.

I mean, what I need to do is sort the X-axis, the date, in ascending order like below.

When I tried, the only blue graph was sorted.

The orange bars should be reversed, too.

How can I do that?

Here is the file.

http://blogattach.naver.com/b421a81...9344_15joG6_xlsx/samsung.xlsx?type=attachment

Thank you very much in advance.

 

[oldbrewer]

you have clearly sorted the dates so I can only surmise that the orange data is as plotted and the dates are just text labels, highlight chart then charts, source data (or just see what data is surrounded by the jiggle line)