Forum Discussion
Solved
X-axis values don't correspond to table values
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?
4 Replies
- And we have a winner! That did the trick. Thx!
It works in my spreadsheet. See attached file.
- 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?
