Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 36
Default reordering dates in worksheet for charting

Hello all! Thanks in advance for any and all assistance here.

I inherited a worksheet that has historical data over time. The monthly
data is updated in columns with the most recent column on the left, and the
oldest data on the left. I would like to use this data to create a chart,
but would like the chart to flow left to right (January-December), instead of
the way the data is presented (December-January).

Is there an easy way of doing this? Transpose on the Paste Special command
won't put the data in the correct presentation, either.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Reordering a List in Numerical Order Bob Excel Worksheet Functions 13 December 5th 06 12:57 PM
Graphing or charting dates tjsmags Charts and Charting in Excel 0 September 4th 06 02:47 PM
Reordering Bars in Bar Graphs [email protected] Charts and Charting in Excel 0 July 18th 06 05:58 PM
Charting with dates changetires Charts and Charting in Excel 1 June 29th 06 09:55 PM
Charting data against dates where dates are not at fixed intervals PK Charts and Charting in Excel 4 June 16th 05 05:08 AM


All times are GMT +1. The time now is 09:07 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"