Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 13th 15, 08:59 PM
Junior Member
 
First recorded activity by ExcelBanter: Jan 2014
Posts: 1
Default 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
Attached Images
File Type: pdf GANTT CHART_2-13-15.pdf (17.4 KB, 183 views)

  #2   Report Post  
Old February 13th 15, 10:17 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2011
Posts: 3,812
Default 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


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 - Collapse multiple values, same label on same line? Ivano Harris[_2_] Charts and Charting in Excel 0 April 16th 10 05:34 PM
Gantt Chart! Scott_goddard Charts and Charting in Excel 1 April 9th 10 01:54 PM
Gantt Chart adel Charts and Charting in Excel 1 November 18th 06 02:38 PM
Color points on Gantt Robin G Charts and Charting in Excel 2 November 21st 05 07:57 PM
Gantt chart Aloysicus Charts and Charting in Excel 1 August 6th 05 11:32 PM


All times are GMT +1. The time now is 06:01 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017