Forum Discussion
Solved
X-axis showing wrong date
Why can't I get the x-axis to show end-of-month-dates? The input sheet only has end-of-month-dates.
4 Replies
- It appears you are using a scatter plot which I normally recommend and/or is the solution to why something isn't working for someone else .... But in this case I think that is the problem for you. As you note the options just aren't there to specify using the last day of the month (at least not that I know of). Assuming you are plotting EVERY month anyhow, I suggest you use a 2-d line and define the 'Label' axis as the end of month dates in your sheet.
mtarler
I actually think I am using a normal line chart, at least that is what it says when I click on "change chart type" to double check.I'm not entirely sure what you mean when suggesting using a 2-d line? Do you mean an additional series and use this series to plot the x-axis instead of using the build in x-axis?
I thought the fact that I set the start date to an end-of-month-date would automatically make the x-axis using that number. It was a while since I worked with excel, but as I seem to recall it it used to work.
