Excel stacked bar showing a date of 1900

[taylo40]

Hello,

I wonder whether you can help me. I want to use excel to produce a stacked bar chart to show the various dates in a project life cycle.

Cell A1 has the project name
Cell B1 has text item of 'Project Start'
Cell C1 has text item of 'Project Build'
Cell D1 has text item of 'Project Finish'

Cell b2 has a date of 01/01/2010
Cell C2 has a date of 31/03/2010
cell d3 has a date of 31/12/2010

When I finish the chart, on the x axis, excel shows the date of 1900 ?? (as in the centuary)

Any ideas

taylo40

 

[Gruuuu]

Since Excel stores dates as number of days since a specific point in time, adding dates together will show you the day that results in a COMBINATORIAL number of days.

In order to get the results you want, every date after the first will have to be the difference, in number of days, of the next result from the prior.

Example:

[b]Sequence   Date        Chart_Date[/b]

1          01/01/2010  40179
2          31/03/2010  89
3          31/12/2010  275

You can just use a formula as such:

=B2-B1

...along column C

 

[SkipVought]

Hi,

It's much easier to COPY 'n' PASTE your specific example like...
[tt]
My Project Project Start Project Build Project Finish
1/1/2010 3/31/2010 12/31/2010
[/tt]
faq68-5827

You 1900 dates are ZEROES.

I'm guessing that your Project Build & Project Finish DATES are not REAL dates. Change the format on them to GENERAL and see if the display changes to a NUMBER. If NOT, you do not have REAL DATES.

READ & UNDERSTAND the faq, to know why.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[xlhelp]

What you need is to plot a Gantt chart. Here are instructions on how to do it.

You will definitely need to modify your data.

Canadian eh! Check out the new social forum Tek-Tips in Canada.
With the state of the world today, monkeys should get grossly insulted when humans claim to be their decendents