Create accumulated chart

(0) Share

Report

Posted on by Community Member

Hi all,

I'm trying to create a chart which shows the sum of actual revenue for each month last 12 month with columns. But I would also like to have in the same graph a line which shows the accumulated value. Is this possible? Any help is much appreciated. The attached image is just an illustration made in Excel to exemplify this.

2017_2D00_02_2D00_02-10_5F00_26_5F00_45_2D00_Book1-_2D00_-Excel.png

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

Nithya Gopinath 17,078 on at

Like (0)

Report
Copy link

Link copied!

Hi Jonathan,

Refer the community thread below.

community.dynamics.com/.../167988

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Nithya,

I don't understands how that link helps me. The question seems to be same but the reply shows a graph which to me doesn't look like a accumulated graph and the referred link doesn't say anything about that. It just describe the basics of creating a chart. Have I misunderstood your referred post?

Was this reply helpful? Yes No
Daniel at VNS on at

Like (0)

Report
Copy link

Link copied!

I'm pretty sure that the only way to do this sort of a chart is using PowerBI. The OOB charting functionality of CRM, even in the latest release is pretty limited.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Ok, Thanks Daniel

Was this reply helpful? Yes No