View Single Post
  #1   Report Post  
JonMulder
 
Posts: n/a
Default X Axis Labels every 96th Data Point

I have a chart showing water levels in a canal at 15 minute intervals (this
was pulled from an automatic data logger on the canal). I have three columns
of data:
Column 1: Date
Column 2: Time
Column 3: Water level
My series1 data comes from the Column 3. My Column 1 data contains the same
date for 96 consecutive rows (i.e. a water level reading every 15 minutes
over a 24 hour interval equals 96 data entries). I want to label the x axis
with the date label every 96th data point. I have been able to set the
X-axis gridlines to show every 96th data point.
-----How can I show an X-axis data label every 96th data point?
Thanks,
Jonathan Mulder
Durham, CA