Excel - reverse data order 3

[binaryfingers]

Hi

I have a spreadsheet that has data entered on it from December 2005 back to January 2003, with December 05 being Column E and January 2003 being column AN. this is great for being able to read newest data first.

however my challenge comes when performing charts, as usually the timeline starts the chronogically with Jan03 being first and Dec 05 being the last, and therefore seeing the trends as you would expect.

Row 6 contains the dates
Row 7 contains the data.

Is there an easy way of either having the charts show in reverse order without flipping the axis locations to the other side, or reversing the data on the spreadsheet, without having to rekey it in column by column.

Thanks,

 

[mintjulep]

Data | Sort | Options....

Sort Left to Right

 

[binaryfingers]

mintjulep

WOW, something so simple, but so effective. I use the sort all the time, didnt even think to look at options!

Have a star, Saved me a lot of time and such a fast response!

Thanks

 

[SkipVought]

Hi,

If you were to have your SOURCE DATA in a normalized table, then you could REPORT, using a Pivot Table with your Dates in either ascending or descending sequence in a matter of a few seconds.

Otherwise, you will be into restructuring your data as you have described that you would rather not do.

Of course, you could also write a VBA procedure the resturcture the data. But if I were going to expend that kind of effort, I'd do it proper and structure a good source data table.

http://www.alphabetcitydataworks.com/FundamentalsOfRelationalDatabaseDesign.doc

Also check out ...

NORMALIZE Your Table using the PivotTable Wizard faq68-5287

Skip,

_{[red]Be Advised![/red] The Vinyards of Texas have produced a wine with diuretic dimishment and urethric relief...
Pinot More!}

 

[SkipVought]

Good tip mintjulep!

Skip,

_{[red]Be Advised![/red] The Vinyards of Texas have produced a wine with diuretic dimishment and urethric relief...
Pinot More!}

 

[AnotherHiggins]

mintjulep, I never noticed that. 'Good to know.

Still, binaryfingers, I would recommend that you fix your data table. Your dates should go [!]DOWN[/!], not across. Keep in mind that there are only 256 columns, whereas there are 65,536 rows. Also, it will be easier to see more of the data if you have it organized this way.

Luckily for you, fixing this is a breeze.

[ul][li]Copy the entire table[/li]
[li]Select a cell below that data[/li]
[li]Right click[/li]
[li]Select Paste Special[/li]
[li]Choose Transpose[/li]
[li]Click OK[/li][/ul]

[tt]_____
[blue]-John[/blue][/tt]

Help us help you. Please read FAQ181-2886 before posting.

 

[binaryfingers]

Thanks for the tips, Skip and anotherhiggins, I really need to learn better structuring and the use of Pivot tables/charts. Im sure half of what I try to do could be so much easier if I used Pivots. time to find the time to learn!