Thread: 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

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 G@discussions.microsoft.com> wrote in message
news:924C247C-507A-4045-9940-CFBDC5C1C304@microsoft.com...
>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 G@discussions.microsoft.com> wrote in message
> news:924C247C-507A-4045-9940-CFBDC5C1C304@microsoft.com...
> >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
> >
>
>
>