Graphical Indicators

K

Kevin Lisboa

I'm working with Project Server 2002 Professional.

We've put together a portfolio view under Project Center
where we can see all the project plans with graphical
indicators - for cost, schedule, risk, etc.

We've also used some coding to create a Print Portfolio
Option, that efectively creates an extract of the whole
portfolio and renders it into an Excel-document that can
be printed.

The problem here is that the extract does NOT retain the
graphical indicator colors. The fields revert back to
their numeric values rather than graphical indicator
markers.

Any ideas or suggestions?

--Kevin
 
J

John Beamish

In answer to a similar question, I wrote:

Project exports the data -- not the representation of the data.

In Excel you'll have to use Conditional Formatting.

The Excel steps are fairly simple:
1. Select the cells
2. Format | Conditional formatting ...
3. Set the conditions

As part of setting the conditions, make selections in both the "patterns"
tab (the cell background colour) and the "text" tab. If you select a text
colour that is the same as the pattern colour you will hide the actual
values and simply display coloured cells.

If you want to display a graphic rather than simply use a coloured cell,
you'll probably have to visit an Excel newsgroup.

JLB, PMP

I'm working with Project Server 2002 Professional.

We've put together a portfolio view under Project Center
where we can see all the project plans with graphical
indicators - for cost, schedule, risk, etc.

We've also used some coding to create a Print Portfolio
Option, that efectively creates an extract of the whole
portfolio and renders it into an Excel-document that can
be printed.

The problem here is that the extract does NOT retain the
graphical indicator colors. The fields revert back to
their numeric values rather than graphical indicator
markers.

Any ideas or suggestions?

--Kevin
Click to expand...



--
 
G

Guest

John,

To your post, I had figured as much, but wasn't certain if
there was some way to "rip" those indicators from the
application.

The major downfall with Project Server 2002 is that it is
not printer friendly in the least bit. Nor is it report
friendly. You cannot "freeze" a column (such as Project
Name) and scroll to the side of Project Center to see the
project detail information without losing sight of the
projects title.

What a miserably frustrating tool this application is
turning out to be.

--Kevin
 
Top