ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to make a time phased line chart (https://www.excelbanter.com/excel-discussion-misc-queries/233314-how-make-time-phased-line-chart.html)

jzis

How to make a time phased line chart
 
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


All times are GMT +1. The time now is 11:53 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com