Neat Excel Chart Date Axis Not Working
C iferror index DataValuesmatch a1DataDates0na.
Excel chart date axis not working. 2 Then the set the Charts data range to another worksheet Cannot be the same worksheet with Chart. Even the correct values are displayed when I open the select data source. I want to add another couple of months to my chart.
Follow the steps above to open Axis Options to set your x-axis to Date Axis if Excels default chart does not do so. In the popped out Format Axis dialog check Text axis option in Axis Type section. Change your data to the Date format to take advantage of Date Axis.
If your date data is entered as text instead of the Date format then the Date Axis option will not work. Right click at the X axis in the chart and select Format Axis from the context menu. 1 moving the data table to another worksheet.
That will work perfectly now can hide the chart while maintain axis-x correctly. As appropriate choose either Text Axis or Date. My problem is this.
The released columns cells are formatted as dates but for some reason the horizontal axis on the scatter plot is starting at 1900. And you should be able to. Do something similar for the y-axis.
I r-clicked on the chart selected Data Sources and went through each of my data series on the left side of this window to. If you have another model its better to illustrate on sample file. QA for work.