Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
GANTT chart - Collapse multiple values, same label on same line? | Charts and Charting in Excel | |||
Gantt Chart! | Charts and Charting in Excel | |||
Gantt Chart | Charts and Charting in Excel | |||
Color points on Gantt | Charts and Charting in Excel | |||
Gantt chart | Charts and Charting in Excel |