Shifting chart data

[MVF]

Hi all! I am trying to create a chart with data that refreshes every month. I get new data every month, but when I go to chart it, it puts all the information on the same horizontal axis. For reference...

[TABLE="width: 575"]
<TBODY>[TR]
[TD]Data Month</SPAN>[/TD]
[TD]Product</SPAN>[/TD]
[TD]Nov-12</SPAN>[/TD]
[TD]Dec-12</SPAN>[/TD]
[TD]Jan-13</SPAN>[/TD]
[TD]Feb-13</SPAN>[/TD]
[TD]Mar-13</SPAN>[/TD]
[/TR]
[TR]
[TD]Nov</SPAN>[/TD]
[TD]Cars</SPAN>[/TD]
[TD="align: right"]985</SPAN>[/TD]
[TD="align: right"]965</SPAN>[/TD]
[TD="align: right"]809</SPAN>[/TD]
[TD="align: right"]802</SPAN>[/TD]
[TD="align: right"]762</SPAN>[/TD]
[/TR]
[TR]
[TD]Dec</SPAN>[/TD]
[TD]Cars</SPAN>[/TD]
[TD][/TD]
[TD="align: right"]965</SPAN>[/TD]
[TD="align: right"]869</SPAN>[/TD]
[TD="align: right"]762</SPAN>[/TD]
[TD="align: right"]722</SPAN>[/TD]
[/TR]
[TR]
[TD]Jan</SPAN>[/TD]
[TD]Cars</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]869</SPAN>[/TD]
[TD="align: right"]737</SPAN>[/TD]
[TD="align: right"]705</SPAN>[/TD]
[/TR]
</TBODY><COLGROUP><COL span=2><COL><COL span=4></COLGROUP>[/TABLE]

So in Nov, I was told we'd sell 762 cars in Mar-13. In Dec, it dropped to 722. I'd like to graphically depict it, but when I go to chart, it puts all the data starting in November. I would like the line in Dec to start with Dec-12, Jan in Jan-12, etc. Any ideas?

Thanks!!!

 

[Andrew Poulsom]

If I select your sample data and insert a column chart, Nov-12 has only one column and Dec-12 has only two. The remaining months have three. Are you doing something differently?

 

[MVF]

Thanks for the reply! I am using line charts. At any rate, in any given month, I don't look at any previous data. So in Nov, I would have a line that includes that Nov, Dec, Jan, Feb etc.... In Dec, it would start in Dec and include Jan, Feb, etc...

I want the X axis to show starting in November, and the Dec data would start there, not in November. Does this clarify the data?

Thanks again!

 

[Andrew Poulsom]

When you get new data select it all, including the Data Month and Product columns, right click and choose Copy. Then right click your chart and choose Paste.

 

[MVF]

Wow! That will save a TON of time. Thanks!!!