In Primavera when we show Resource Usage Profile or Activity Usage Profile, the max value in Y-Axis is determined by software. And we may wonder how is it determined.

I will explain in this article.

First, it depend on what is your Timescale. It is by week, month, or year. Base on that, P6 know the max value (highest bar) of your diagram.

We have a simple project.

You can see the max value is 8 hours.

Then the calculation of Y-axis is like this:

- MaxY = Max * 1.2 = 8 * 1.2 = 9.6 hrs
- The number of intervals on the Y axis is always 6. There are always 5 labels on Y axis. The uppermost interval is not labeled.

Interval size = MaxY / number of intervals. (9.6 / 6 = 1.6) - Round the interval size. The
**leftmost**digit is rounded up. (1.6 -> 2) - Multiply rounded interval size by 6 to get new MaxY axis value (2 * 6 = 12)

In this example the y-axis will be labeled in intervals of 2 with a max value of 12.

Note:

- All calculations are done in hours, the display is then converted to days or other specified time unit.
- Remember “the
**leftmost**digit” idea. For example, if you have the value 1200, P6 will round up to 2000.

**So now we know How Primavera determine Y-Axis scale in the Resource/Activity Usage Profile**

Good to know. By the way, can please let us know; how to adjust cum value in the S curve adjust to 100%. Appreciate your write up on P6.

LikeLike

Hi. From my experience, it seem that P6 doesn’t support to show Y-axis in %. It only support Units or Cost

LikeLike

You can export data to Excel and change Y-axis to % complete. Kindly refer to this article https://doduykhuong.com/2016/02/04/graphing-a-p6-resource-s-curve-in-excel/

LikeLike

Thank you. I never knew how he Y axis was configured. Is Max Value influenced by the number of resources eg What is the Max Value for 6 Laborers on a Year/Quarter timescale.

LikeLike

Hi Nancy.

When you select 6 laborers, the total unit increase so the max unit will increase

LikeLike