Post

2 followers Follow
0
Avatar

Profit % Per Month Chart

Hi all,

I need a chart that will show % profit of projects month by month.  So the X Axis would be due date and the Y Axis would be % Profit.

I'm just not seeing how to do this.

Any ideas?

Thanks

Martin Jubb Answered

Please sign in to leave a comment.

1 comment

1
Avatar

Hi! 

What you could do is add a formula column (Due Date Month) that converts the month value to a string. Use the if-else statement to do this for each month in a year. Its a bit of work but a possible solution. I've done this for each quarter by using if-else and date between 'x' and 'y'.

Hope this helps ;D

Yari Bernardus 1 vote
Comment actions Permalink