LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 3
Default Chart in time phase

I need to develop a line chart which includes 2 columns of data. Say for
instance the data looks as follows:
5 6
15 9
20 12
50 25

Columns with the 5 and the 6 are for March.
Columns with the 15 and the 9 are for February.
So as we go up, the month increases.

When I make my graph, the 5 and the 6 are first plotted points, the 15 and
the 9 are the second, etc. In other words, it is plotting March, February,
January, instead of January, February, March.

How can I make the chart plot in a logical time phased manner? That is,
Jan, Feb, Mar, etc?

Thanks.
jzis


 
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
Phase reporting Jonathan B. Excel Discussion (Misc queries) 3 July 25th 06 05:13 PM
Trying to report the current phase of a project Jonathan B. Excel Discussion (Misc queries) 2 July 24th 06 04:31 PM
Phase change line on a graph? tobyhons Excel Discussion (Misc queries) 1 May 16th 06 08:25 PM
phase line in an Excel graph tobyhons Excel Discussion (Misc queries) 0 December 15th 05 02:09 PM
Anchor a phase change line? skinnerbox99 Charts and Charting in Excel 1 August 6th 05 12:12 AM


All times are GMT +1. The time now is 07:29 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"