Dynamically change X axis on chart 1

[kimmer7389]

How do I change the X axis on a chart to only show the months for the date range entered?

The data is displaying the correct data points but my x axis is showing all the months and years ever entered into the database

 

[SkipVought]

Hi,

Change the X-Axis from a CATEGORY to a TIME axis.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[kimmer7389]

Not sure what you mean. When I am in the Format Axis window the category is set as a Date.

 

[SkipVought]

In Chart Options.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[kimmer7389]

Sweet! That worked! Thank you.