How do I eliminate day between two dates i.e. fortnightly

F

Frustrated Charter

I have a spreadsheet which I record fortnightly data in. When I create a
chart, the chart is picking up the days in between the fortnight dates and
messing up my graph. I only want to show the actual dates ie the each
fortnight in my chart
 
A

Andy Pope

Hi,

Sounds like you need categorical axes rather than time series.
Right click chart and from the popup menu chose Chart Options. On the
Axes tab set the X axis to being Category rather than Automatic.

Cheers
Andy
 
Top