+ Reply to Thread
Results 1 to 3 of 3
  1. #1
    Robin G
    Guest

    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


  2. #2
    Jon Peltier
    Guest

    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
    >




  3. #3
    Robin G
    Guest

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

    >
    >
    >


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.2.0