X-axis values don't correspond to table values

[ala6xxxx]

I created a chart table that I inserted into a line chart with markers. The chart table consists of rows made up of dates (mm/dd/yy format) and dollar amounts. I started the dates at 12/31/05, then continued with 06/30/06, 12/31/06, 06/30/07, 12/31/07 and so on. Instead of those values showing on the x-axis, I get 12/01/05, 06/01/06, 12/01/06, 06/01/07, 12/01/07, etc. How do I get the correct values to display?

[#2]

@ala6xxxx 

It works in my spreadsheet. See attached file.

[#3]

Interesting. When I originally created the table, all I had were years (no months and days) and amounts, then I just added additional rows and changed the format to mm/dd/yy. I'm wondering if that messed things up and I need to create and use an entirely new table?

[#4 · Accepted solution]

@ala6xxxx 
SELECT CHART 
on the right side open format axis option.
axis type> text axis

[#5]

And we have a winner! That did the trick. Thx!