Floating bars

Hiya-

I need to make a gannt-type chart from a ton of data in excel. I've never
had to make a chart with excel without numbers so this is new to me. I've
got a ton of grants (y-axis) and I want to chart where they started and where
they finished (x-axis). There are 6 stages where they could have started or
finished and ideally I'd like to be able to have the start date shown at the
base (left end) of the floating bar.

Please let me know if this is possible with excel and ideally forward me a
template that I could cannibalize.

Cheers,
tripp

On Sat, 8 Mar 2008, in microsoft.public.excel.charting,
cdw <cdw@discussions.microsoft.com> said:
>I need to make a gannt-type chart from a ton of data in excel.

>Please let me know if this is possible with excel and ideally forward me a
>template that I could cannibalize.

Google "Excel Gantt-chart"

--
Del Cotter
NB Personal replies to this post will send email to del@branta.demon.co.uk,
which goes to a spam folder-- please send your email to del3 instead.

http://pubs.logicalexpressions.com/...icle.asp?ID=343
http://peltiertech.com/Excel/Charts/GanttChart.html
http://peltiertech.com/Excel/Charts/GanttLinks.html

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


"cdw" <cdw@discussions.microsoft.com> wrote in message
news3F3D654-EDE9-495B-8867-18A1CF82A61B@microsoft.com...
> Hiya-
>
> I need to make a gannt-type chart from a ton of data in excel. I've never
> had to make a chart with excel without numbers so this is new to me. I've
> got a ton of grants (y-axis) and I want to chart where they started and
> where
> they finished (x-axis). There are 6 stages where they could have started
> or
> finished and ideally I'd like to be able to have the start date shown at
> the
> base (left end) of the floating bar.
>
> Please let me know if this is possible with excel and ideally forward me a
> template that I could cannibalize.
>
> Cheers,
> tripp
>
>