Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Color points on Gantt
I have created a pseudo Gannt Chart which is a calendar of when these people
are out of the country. The plot excludes the first column of data. Name is on the y axis and the bar starts at Date and continues for 'remaining' days. I would like to automatically color each datapoint by region. Any ideas? Region Name Date completed remaining Africa Smith, John Oct-01 1,461 Africa Saglimbeni, Ken Jan-04 639 Eurasia Webby, Michelle Apr-05 208 Africa Krucker, Ben Dec-01 1,461 Asia Pacific McClure, Emily Apr-05 269 Asia North Spears, Susan Aug-03 878 Latin America Speer, Cathy Jan-04 721 Asia Pacific Clauser, Jeff May-04 699 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Color points on Gantt
Thanks, it worked like a charm!!
"Jon Peltier" wrote: Use the conditional charting example on my web site: http://peltiertech.com/Excel/Charts/...nalChart1.html Make a column for each region, and set the formulas so the value in each column is zero (not NA() for a stacked bar chart) or the number of days remaining. Use the Date and the regional columns for the stacked bar data. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "Robin G" <Robin wrote in message ... I have created a pseudo Gannt Chart which is a calendar of when these people are out of the country. The plot excludes the first column of data. Name is on the y axis and the bar starts at Date and continues for 'remaining' days. I would like to automatically color each datapoint by region. Any ideas? Region Name Date completed remaining Africa Smith, John Oct-01 1,461 Africa Saglimbeni, Ken Jan-04 639 Eurasia Webby, Michelle Apr-05 208 Africa Krucker, Ben Dec-01 1,461 Asia Pacific McClure, Emily Apr-05 269 Asia North Spears, Susan Aug-03 878 Latin America Speer, Cathy Jan-04 721 Asia Pacific Clauser, Jeff May-04 699 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you create an Excel Gantt chart with double bar per line item ? | Excel Worksheet Functions | |||
2 or more layers on a Gantt Chart(Excel 2002) | Charts and Charting in Excel | |||
Where is a Gantt chart template? | Excel Discussion (Misc queries) | |||
How do I add an indicator line to a Gantt chart in excel? | Charts and Charting in Excel | |||
Gantt chart | Charts and Charting in Excel |