#1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 5
Default Gantt Chart

Good morning,

I wanted to create a small Gantt chart via Excel using conditional
formatting with weeks instead of days. Everything seems to be working fine
except when a project starts and finishes within the same week. It doesn't
show anything.

What would be the proper way to have a a cell refering to the beginning of
the week so that it is being shown in my chart??

Thank you very much for your help.


  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1,071
Default Gantt Chart

I suspect this is too abstract a problem definition to get an answer.

How are you storing the weeks? Are they just numbers (1, 2, etc.) or actual
dates?

What are you doing (i.e., what conditions) in terms of the conditional
formatting?

Some more specifics may elicit an answer from someone.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
Good morning,

I wanted to create a small Gantt chart via Excel using conditional
formatting with weeks instead of days. Everything seems to be working fine
except when a project starts and finishes within the same week. It doesn't
show anything.

What would be the proper way to have a a cell refering to the beginning of
the week so that it is being shown in my chart??

Thank you very much for your help.



Reply
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
Gantt chart - fill show progress of tasks over task time period??? JohnHamer1977 Excel Discussion (Misc queries) 3 August 29th 06 05:41 AM
How do I create a Gantt Chart in Excel 2003? Bewildered KG Charts and Charting in Excel 1 June 22nd 06 08:16 PM
Gantt Chart? BChambers Charts and Charting in Excel 1 February 10th 06 08:07 PM
Gantt Chart in Excel. Do I need conditional formatting? Shan Charts and Charting in Excel 1 November 16th 05 02:05 AM
Activating a Chart object Hari Prasadh Charts and Charting in Excel 6 August 2nd 05 07:22 PM


All times are GMT +1. The time now is 11:39 AM.

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

About Us

"It's about Microsoft Excel"