LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Gudrun
 
Posts: n/a
Default Number of labels on X-axis one more than number of values on Y-axi

I am making a graph with columns, where each column represents water use on a
certain time interval. I have 38 time intervals which are, each one, defined
by an initial and final date, such that the final date for one column is
always the initial date for the next column.

I have the dates on the category (X) axis, and they have to be exact. (E.g.
the first date is 24.1.1966, the next is 8.2.1967 and so on until 6.1.2004).
There is never the same number of days between two dates so the only way I
see to keep the exact dates is to define the axis as a category axis (not
€śTime-scale€ť).

So here is my problem:
The number of dates is one more (39) than the number of columns, and I want
the first date to be right below a tick mark at the LEFT side of the first
column and so on. Then I want the last date to be right below a tick mark at
the RIGHT side of the very last column.

The tick marks are at the right place BUT, the first date appears right
below the middle of the first column and so on, and the last date is always
missing!


Does anyone know a way to fix this or is it maybe impossible to have the
number of labels one more than the number of values? !!



 
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
Can tick mark labels be flipped about axis? [email protected] Charts and Charting in Excel 1 July 20th 05 05:03 PM
Bar chart & Category (x) axis labels Airi A. Charts and Charting in Excel 0 March 15th 05 03:09 PM
Bar chart & Category (x) axis labels Airi A. Charts and Charting in Excel 0 March 15th 05 03:09 PM
Labels on Chart with Negative Value Axis David F. Schrader Charts and Charting in Excel 6 December 17th 04 06:25 PM
Linking Axis Labels Neil Charts and Charting in Excel 2 December 5th 04 09:04 PM


All times are GMT +1. The time now is 04:13 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"