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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I get the Fortnight number of the year from a date? 1
Get Fortnight intervals 5
How do I flag up fortnightly repeating cycles? 2
Update Graph Data Automatically 2
How do I construct a bi-weekly subject schedule for 2006/7? 1
Dynamic range 1
Complex Date chart question 2
A line across my area chart 1

Back
Top