Force chart to display all x axis labels

I have an xy scatter chart that plots computer outages versus days of the
month. Is there a way to force the chart to show all x axis labels? eg. for
the month of May I want the x axis to show all 31 labels and associated tick
marks (1-May through to 31-May).
Currently the chart only displays every third label. eg 1-May, 4-May, 7-May
etc.
Regards
MartinWhile playing around with this I have found some strange chart behaviour.
On the x axis I am plotting datetime values from a SQL stored proc. The x
axis chart properties are setup with a format code of dd-MMM-yyyy and the
'Numeric or time-scale values' checkbox checked. With these properties set
the chart only displays every third x axis label (1-May-2005, 4-May-2005
etc).
If I uncheck 'Numeric or time-scale values' and then view the chart I see 31
labels on the x axis but on the days that contain NULL y-axis data, the x
axis label is displayed as dd-MMM-yyyy!
Any ideas how to fix this?
"Martin Hinchy" wrote:
> I have an xy scatter chart that plots computer outages versus days of the
> month. Is there a way to force the chart to show all x axis labels? eg. for
> the month of May I want the x axis to show all 31 labels and associated tick
> marks (1-May through to 31-May).
> Currently the chart only displays every third label. eg 1-May, 4-May, 7-May
> etc.
> Regards
> Martin
>|||Got all dates on x-axis to display by checking the 'Numeric or time-scale
values' checkbox and specifying the x-axis major gridline interval as 1.
Now found another problem. If my dataset returns three values for the one
day then only the first value is plotted. Anyone know why?
"Martin Hinchy" wrote:
> While playing around with this I have found some strange chart behaviour.
> On the x axis I am plotting datetime values from a SQL stored proc. The x
> axis chart properties are setup with a format code of dd-MMM-yyyy and the
> 'Numeric or time-scale values' checkbox checked. With these properties set
> the chart only displays every third x axis label (1-May-2005, 4-May-2005
> etc).
> If I uncheck 'Numeric or time-scale values' and then view the chart I see 31
> labels on the x axis but on the days that contain NULL y-axis data, the x
> axis label is displayed as dd-MMM-yyyy!
> Any ideas how to fix this?
> "Martin Hinchy" wrote:
> > I have an xy scatter chart that plots computer outages versus days of the
> > month. Is there a way to force the chart to show all x axis labels? eg. for
> > the month of May I want the x axis to show all 31 labels and associated tick
> > marks (1-May through to 31-May).
> >
> > Currently the chart only displays every third label. eg 1-May, 4-May, 7-May
> > etc.
> >
> > Regards
> > Martin
> >
> >