ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Floating bars (https://www.excelbanter.com/charts-charting-excel/179322-floating-bars.html)

cdw

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



Del Cotter

Floating bars
 
On Sat, 8 Mar 2008, in microsoft.public.excel.charting,
cdw 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 ,
which goes to a spam folder-- please send your email to del3 instead.

Jon Peltier

Floating bars
 
http://pubs.logicalexpressions.com/P...cle.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" wrote in message
...
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






All times are GMT +1. The time now is 04:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com