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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top