How do I change the format of the x axis on a chart when everything is grayed out? Other charts are fine.
How do I change the format of the x axis on a chart when everything is grayed out? Other charts are fine.
Which type of chart (line, scatter, ..... there a plenty types)? Have you got a sample file to upload? There must be differences in charts working and those which don't. And it's impossible to recognize from a distance without a fortune teller.
It is a line chart. The axis is supposed to show dates and that is what cell references refer to, but instead it shows the numbers from 1 to 32 (that is not what is in the data). I have since noticed other charts where the place to change the axis is also grayed out, but I'm not trying to change those since they read correctly.