Week numbers on X-axis

  • Thread starter Thread starter Konpego
  • Start date Start date
K

Konpego

Hi,

I have a chart that should display the project status over
a number of weeks. It all works fine when you have a
continous array of weeks (e.g w430 - w450).
But when the projects runs over the NewYear (e.g w430 -
w506) I have problems with my x-axis. The week numbers
(430 - 506) appears to the left on the x-axis and to the
right I only get marks on the axis but no numbers.
I would like to have the weeks spread evenly on the x-
axis, starting with 430 and ending with 506 (an across the
New Year; ... 451, 452, 452, 501, 502 etc).
I save the wanted x-axis in an array (1 to LastWeek) and
wants the contents of the array to be displayed on the x-
axis.
Tips?
 
Was that your question about the number of X axis ticks? Store your array in a
worksheet to avoid limits on the length (number of characters) of the series formula.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Back
Top