locked
Average line in chart RRS feed

  • Question

  • Hi,

    Is there a way of getting an average line in a MS Project report, like the green one, which refers to the budget sales at 450 000? Have it manually made now, but as the report is exported automatically the Y scale may change and the line end up at the incorrect position. Can set the scale to fixed, but is there a way of doing this if you do want the scale to be automatic?

    Grateful for any ideas.

    Kind regards //Anders

    Tuesday, November 18, 2014 10:37 AM

Answers

  • Hi At_lamnea,

    In the chart you can only display values from MSProject, and the value needs to be timephased; alas the custom cost fields that you could use to hold such data are not timephased, and therefore I don't think this is automatically achievable.


    Ben Howard [MVP] | web | blog | book | P2O

    • Marked as answer by AT_lamnea Tuesday, November 18, 2014 11:17 AM
    Tuesday, November 18, 2014 10:55 AM

All replies

  • Hi At_lamnea,

    In the chart you can only display values from MSProject, and the value needs to be timephased; alas the custom cost fields that you could use to hold such data are not timephased, and therefore I don't think this is automatically achievable.


    Ben Howard [MVP] | web | blog | book | P2O

    • Marked as answer by AT_lamnea Tuesday, November 18, 2014 11:17 AM
    Tuesday, November 18, 2014 10:55 AM
  • Ok Ben, thank you.

    Will set the scale to Auto then.

    Kind regards //Anders

    Tuesday, November 18, 2014 11:17 AM