Line Charting Problem

[Matt_jay50]

Hello all,

I'm relatively new to excel and im having a problem getting my data to match up in a line chart.

I have three lines I would like to show (years 2007, 2008, and 2009) all with the different months plotted along different points (the y axis is the number amount, the x is the actual month name). The problem I'm running into is that I only have partial years for 2009 and 2007 (i only have 6 months for 2009 and 2 months for 2007) and I can't seem to get the data to match up with the points of the lines above the correct months.

In addition, I was wondering if there was any way to reverse the line and months so that the line contains the same points, just in reverse (corresponding with the correct x axis months, also reversed).

[Andy Pope]

You will need to post a workbook of what you currently have for us to fully understand your problem