arc90 lab | tools: Link Thumbnail
Excel Help Forum
ExcelTip.com
Account Icon Account Icon Account Icon
ExcelTip.com

Go Back   Excel Help Forum > Microsoft Office Application Help - Excel Help forum > Excel Programming > Excel Charting

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 11-21-2005, 11:25 AM
Robin G
Guest
 
Posts: n/a
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

Reply With Quote
  #2  
Old 11-21-2005, 01:00 PM
Jon Peltier
Guest
 
Posts: n/a
Re: Color points on Gantt

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
>



Reply With Quote
  #3  
Old 11-21-2005, 03:00 PM
Robin G
Guest
 
Posts: n/a
Re: 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 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
> >

>
>
>

Reply With Quote
Reply

Bookmarks

New topics in Excel Charting


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off
Forum Jump


All times are GMT -4. The time now is 07:55 PM.


Powered by vBulletin® Version 3.7.4
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0