Re: Week numbers on X-axis

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Jon Peltier (DOjonNOTxlmvp_at_SPAMpeltiertechME.com)
Date: 10/09/04 

Date: Fri, 08 Oct 2004 23:30:07 -0400

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/
_______

Konpego wrote:

> 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?

Relevant Pages

  • Re: Promoting unsigned long int to long int
    ... I'm using the quick sort method. ... The array of pointers ... The axis can take ... Since i and j are equal you get into this loop. ...
    (comp.lang.c)
  • Re: ExceptionInInitializerError in Castor
    ... I tried printing the byte array and it prints the exact xml file that is being sent by the application calling this webservice. ... I am running axis on Tomcat 4.1.29 But when I try to unmarshall the byte array, ... Since it seems exceedingly unlikely that one of the Commons Logging's own loggers would fail to implement its Log interface, the most likely scenario is multiple versions of the Commons Logging package in the classpath. ... This sort of thing sometimes happens when an application or package, such as Axis, Castor, or Tomcat comes packaged with various external libraries, such as Commons Logging. ...
    (comp.lang.java.programmer)
  • Kalman Filter
    ... I am creating a algorithm suite for a new virtual IMU design. ... based on an array of gyros and accelerometers for each axis. ...
    (comp.soft-sys.matlab)
  • Re: Crypting the webservice responses in AXIS
    ... original array without problems because on the client side the BASE64 ... Before the BASE64 String is sended back, I am interested to encrypt it ... it is possible in some way to ask AXIS to crypt/decrypt ...
    (comp.lang.java.programmer)
  • Week numbers on X-axis
    ... I have a chart that should display the project status over ... w506) I have problems with my x-axis. ... right I only get marks on the axis but no numbers. ... wants the contents of the array to be displayed on the x- ...
    (microsoft.public.excel.charting)