curve s in microsoft project in 2003

J

John

jannette said:
how i can do a curve S in microsoft project 2003

jannette,
The simple answer is, you don't. Project isn't very good when it comes
to graphics capability. You can create an "S" curve, but you will need
to export the data to another application (e.g. Excel).

If you have a version of Project prior to 2007, you can try the "Analyze
timescaled data in Excel" utility found on the "Analysis" toolbar, or
for the most flexibility, you can create your own VBA macro (more on
that later).

If you have Project 2007, you can use the visual reports utility.

Fellow MVP, Rod GIll, wrote a book on Project VBA. One of the examples
in his book is a macro for creating "S" curves. For more information on
Rod's book, go to, http://www.projectvbabook.com

Hope this helps.
John
Project MVP
 
B

Bob

jannette,
The simple answer is, you don't. Project isn't very good when it comes
to graphics capability. You can create an "S" curve, but you will need
to export the data to another application (e.g. Excel).

If you have a version of Project prior to 2007, you can try the "Analyze
timescaled data in Excel" utility found on the "Analysis" toolbar, or
for the most flexibility, you can create your own VBA macro (more on
that later).

If you have Project 2007, you can use the visual reports utility.

Fellow MVP, Rod GIll, wrote a book on Project VBA. One of the examples
in his book is a macro for creating "S" curves. For more information on
Rod's book, go to,http://www.projectvbabook.com

Hope this helps.
John
Project MVP

I've written an SCurve form and control using VBA in project that use
the OWC 11. Works like a charm.

I used the logic in Rod's book (Highly recommended). Also the OWC is
quite poorly documented, so stick with Excel.
I did it because it was fun, and wanted to really learn it.
 
J

John Garay - DecisionEdge

Jannette,

There are also third-party reporting tools for Microsoft Project that
provide S-curve charts.
Just do a search on "Microsoft Project charts" (or whatever) to find other
choices.

Hope this helps.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top