Prev: Copying Excel 2007 Charts as picture into Word
Next: time scale proportional using a column chart - not just for scatte
From: trip_to_tokyo on 24 Mar 2010 16:29
OK, sorry, seems I cannot help any further.

On my laptop dates show as:-

31-Oct08
30-Nov-08
31-Dec-08
31-Jan-09

- etc.

I hope that somebdoy else will be able to assist.



"excel_slave" wrote:

> I closed Excel and opened your file from your website and it displayed the
> axis labels on your chart as:
>
> 31-Oct-08
> 1-Dec-08
> 1-Jan-09
> 1-Feb-09
> etc.
>
> there must be a default setting on my machine or OS that is telling it to
> display time-values as the beginning of a period and not the end. I also got
> a new laptop when I switched from 2003 to 2007 so that may be the issue and
> not a 2003 vs 2007 issue. Thanks for your help.
>
>
> "trip_to_tokyo" wrote:
>
> > I have just put up my file for you at:-
> >
> > http://www.pierrefondes.com/
> >
> > - item number 77 towards the top of my home page.
> >
> > Try deleting the chart and then starting again. If you do this I think that
> > the new chart will pick up the dates in the format that I have suggested.
> >
> > If my comments have helped please hit Yes.
> >
> > Thanks.
> >
> >
> >
> > "excel_slave" wrote:
> >
> > > formatting of the dates did not change anything. Is there a date setting in
> > > Windows that would default all applications to display the end of a period
> > > instead of the beginning?
> > >
> > > "trip_to_tokyo" wrote:
> > >
> > > > EXCEL 2007
> > > >
> > > > If I set things up exactly as you state I get the right days along the X
> > > > axis.
> > > >
> > > > My underlying data for the dates I set up as Custom Format dd-mmm-yy. Maybe
> > > > if you set things up this way you will get the right dates appearing in the
> > > > chart?
> > > >
> > > > If my comments have helped please hit Yes.
> > > >
> > > > Thanks.
> > > >
> > > >
> > > >
> > > > "excel_slave" wrote:
> > > >
> > > > > I am using a time-value x-axis. My minimum point is 10/31/08 and my maximum
> > > > > is 10/31/11. I have the base unit as days and the major unit interval set as
> > > > > months. In Excel 2003, this gave me axis labels of 10/31, 11/30, 12/31 etc.
> > > > > In 2007 it gives me 10/31, 12/1, 1/1 etc. - I cannot figure out how to make
> > > > > it show the labels as of the last day of the month instead of the first day
> > > > > of the next month.
First  |  Prev  | 
Pages: 1 2
Prev: Copying Excel 2007 Charts as picture into Word
Next: time scale proportional using a column chart - not just for scatte