GANTT FORMULA & multiple color bar chart
 

Hi,

Please help me with a FORMULA to create a GANTT CHART from the attached excel file (series of data to be used: Column A (Category), Column B (From date) and Column C (To). Each horizontal bar should be colored as per the corresponding labels in Column A (Category), as follows:
- Maintenance Leased unit (blue color):
- Rental (red color);
- Replacement (purple color):
- Shop invoice (green color):

Thank you,
Moshe

GANTT FORMULA & multiple color bar chart
 

Hi,

Am Fri, 13 Feb 2015 19:59:20 +0000 schrieb moshef:

Please help me with a FORMULA to create a GANTT CHART from the attached
excel file (series of data to be used: Column A (Category), Column B
(From date) and Column C (To). Each horizontal bar should be colored as
per the corresponding labels in Column A (Category), as follows:
- Maintenance Leased unit (blue color):
- Rental (red color);
- Replacement (purple color):
- Shop invoice (green color):

use a stacked bar chart. For the y values add From and Duration.
Then select From and format it with no filling.
The colors for the bars you can change with format of data serie.

Or look he
https://onedrive.live.com/?cid=9378A...121822A3%21326
for "PseudoGantt"


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional