# graph using reverse order data

#### Gayathri Venkatesh

##### New Member
Hi All,
I would like to know if it is possible to plot gragh in the reverse order of data .

Aug-06 Jul-06 Jun-06 May-06 Apr-06 Mar-06 Country
1562 1734 1469 1608 1346 954 COMC
175 216 170 217 205 128 COMC

ie mar06 value should be on the left and aug-06 value on the extreme right . i am using the graph "line - column (custom graph)"

thanks

### Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).
Gayathri Venkatesh

I am not sure that this cannot be done but the lack of responses so far is not promising. So what about reversing the data and then graphing? Here is a way to do the reversing:

Formula in A7 (copied across and down):
=INDEX(\$A\$1:\$G\$3,ROWS(A\$7:A7),COLUMNS(\$A\$1:\$G\$1)-COLUMNS(\$A7:A7)+1)
You may have to then format row 7 with the appropriate date format. Now try graphing A7:G9.
Mr Excel.xls
ABCDEFGH
1Aug-06Jul-06Jun-06May-06Apr-06Mar-06Country
215621734146916081346954COMC
3175216170217205128COMC
4
5
6
7CountryMar-06Apr-06May-06Jun-06Jul-06Aug-06
8COMC95413461608146917341562
9COMC128205217170216175
10
Reverse Chart

The order should be "corrected" by Excel if it recognises the dates as dates.

For a line chart, if you just plot the data, they will line up in date order -- as long as the dates ARE dates, not text.

You will then get the X-axis set up as you need.

If that doesn't work; try Peter's suggestion for reversing the values. Alternatively double-click the X-axis then, on the Scale tab, see it you can reverse values.

Denis

The order should be "corrected" by Excel if it recognises the dates as dates.

For a line chart, if you just plot the data, they will line up in date order -- as long as the dates ARE dates, not text.

You will then get the X-axis set up as you need.

If that doesn't work; try Peter's suggestion for reversing the values. Alternatively double-click the X-axis then, on the Scale tab, see it you can reverse values.

Denis
Denis, I found that the automatic correction failed once I moved from a simple line graph to the Custom Line - Column graph

If your dates are recognized as dates by XL and you want the dates in chronological order, select the chart, then Chart | Chart Options... | Axes tab. In there, make sure the Category (X) axis is set to 'time scale'.

If your dates are not recognized as dates or if you simply want everything in reverse order: Double-click the x-axis. In the resulting dialog box, in the Scale tab, check 'categories in reverse order'.

Hi All,
I would like to know if it is possible to plot gragh in the reverse order of data .

Aug-06 Jul-06 Jun-06 May-06 Apr-06 Mar-06 Country
1562 1734 1469 1608 1346 954 COMC
175 216 170 217 205 128 COMC

ie mar06 value should be on the left and aug-06 value on the extreme right . i am using the graph "line - column (custom graph)"

thanks

Tushar, thanks for the suggestion. First option worked because the dates are recognised by XL.

Thanks everyone for suggestion. I had already reversed the data and tried. Reason i am having latest data first is because every month I add new data and i need to pickup only 6 latest set of data. by keeping latest month data in the front all i need to do is insert column every month in the front and leave historical data still in the spreadsheet

Cheers

You are welcome.

Tushar, thanks for the suggestion. First option worked because the dates are recognised by XL. {snip}

Replies
3
Views
487
Replies
0
Views
454
Replies
7
Views
749
Replies
1
Views
609
Replies
3
Views
374

Threads
1,219,807
Messages
6,150,350
Members
450,952
Latest member
Zung

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back