Forum Discussion
dodonald
4 years agoHelper I
Average tasks opened closed each day in specific month
I am trying to plot the monthly average of # of tasks created and closed each day. My data gives the date of Task Creation and, if closed, the date of Task Closure. I have an area chart that shows th...
dodonald
4 years agoHelper I
amitchandak Thanks! The formulas seem to work. I am not sure how to get the average line to appear on the daily graph, unless I create a constant line and manually enter the value. Can you advise?
v-yanjiang-msft
4 years agoCommunity Support
Hi dodonald ,
The line value is not supported in area chart, have you tried to use the line and clustered column chart instead?
Best Regards,
Community Support Team _ kalyj
If this post helps, then please considerAccept it as the solution to help the other members find it more quickly.