graph using reverse order data

Gayathri Venkatesh

New Member
Joined
Jan 18, 2006
Messages
25
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

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
49,555
Office Version
  1. 365
Platform
  1. Windows
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
 

SydneyGeek

MrExcel MVP
Joined
Aug 5, 2003
Messages
12,251
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
 

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
49,555
Office Version
  1. 365
Platform
  1. Windows
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
 

tusharm

MrExcel MVP
Joined
May 28, 2002
Messages
11,029

ADVERTISEMENT

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
 

Gayathri Venkatesh

New Member
Joined
Jan 18, 2006
Messages
25
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
 

Forum statistics

Threads
1,137,298
Messages
5,680,684
Members
419,924
Latest member
Dhamodharan992

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

Which adblocker are you using?

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
Top