LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Fan charts Dean Charts and Charting in Excel 7 May 30th 05 11:51 AM
Line Graph Data Recognition Nat Charts and Charting in Excel 2 April 30th 05 02:07 PM
Is there a way of attaching data labels from a text range to dat. Peter Sailing by Charts and Charting in Excel 3 March 31st 05 02:25 PM
Linearized data relationships and axes labels Buck121 Charts and Charting in Excel 2 March 31st 05 05:13 AM
Using data as data labels cheekymonkey Excel Discussion (Misc queries) 1 February 18th 05 11:07 PM


All times are GMT +1. The time now is 06:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"