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

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

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