I am working on a report on MS Project 2013. In this report there is chart.

The chart is based :

  • NumberOftasks (Y-axis) which is a custom field of type number.
  • Localization (X-axis) which is done by Grouping the tasks by localization (it is a custom text field).

The awkward situation is that I have a custom field of type text, called typeOftask which take two values : either A or B.

I would like to draw clustered column chart that take in consideration the typeOfTask so that the column is divided into two values : the number of tasks of type A and the number of tasks of type B.

Something like this : enter image description here

Please, how to do that in MS Project 2013 ? I know it is possible ?

  • Sorry, but I'm not clear. You have 2 or three custom fields? Number of tasks which is a number field with a formula? A count? What is localization? A text field? And you've grouped by the field? And to that, you want it further broken down by A & B? What relationship does the number of tasks have to A & B? Have you tried modifying your group to group first by Localisation and then by Type of Task?
    – JulieS
    Jul 22 '15 at 13:21
  • I have three custom fields : NumberOfTasks, Localisation, and typeOfTask , NumberOfTask is a Number (for each task I put 1 and get the count of tasks by sum in summary tasks).
    – user17770
    Jul 22 '15 at 13:24
  • localization is a custom field that contains cities .... it is Text custom field. I grouped the tasks by Localization. When I group by Localization and typeOfTask I don't get a modified chart, rather the axis that is modified if you know what i mean.
    – user17770
    Jul 22 '15 at 13:28
  • Right, I have that part (and you can just use the Count command for the calculation for group or summary rows.) I've done a quick experiment and can't seem to the get second level group (group by Localisation then by type) to show in the chart.
    – JulieS
    Jul 22 '15 at 13:28
  • 1
    Up to you. I'd keep it just in case others have the same question.
    – JulieS
    Jul 24 '15 at 13:05

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy