Prev Previous Post   Next Post Next
  #1   Report Post  
centerNegative
 
Posts: n/a
Default Gantt Chart


I've worked out a fairly decent Gantt-style chart for use in project
management that charts out bars over a timeline for different phases of
a project, given a start date and duration for each phase. The problem I
am having is this project schedule's timeline needs to be based only on
weekdays. I'd like the timeline, showns a series of dates along the Y
Axis or Value Axis, to be broken up into units of five and display the
proper dates for only Mondays through Fridays, work weeks, leaving out
weekends altogether so the chart bars don't get broken up.

Is there any way to leave out weekend days/date from both the Y/Value
Axis and the graph???


--
centerNegative
------------------------------------------------------------------------
centerNegative's Profile: http://www.excelforum.com/member.php...o&userid=24921
View this thread: http://www.excelforum.com/showthread...hreadid=387621

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Urgent Chart Assistance Brent E Charts and Charting in Excel 1 May 10th 05 09:09 AM
Urgent Chart Questions Brent E Excel Discussion (Misc queries) 0 May 9th 05 11:01 PM
Urgent Chart Assistance Requested Brent E Excel Discussion (Misc queries) 0 May 9th 05 11:01 PM
Gantt chart with labels Randhir Charts and Charting in Excel 1 March 3rd 05 03:59 AM
Gantt Chart with variable width columns - is this possible? Dave Charts and Charting in Excel 0 December 13th 04 08:00 PM


All times are GMT +1. The time now is 10:41 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"