Skip to main content

Notifications

Microsoft Dynamics CRM (Archived)

Create accumulated chart

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Create accumulated chart

    Ok, Thanks Daniel

  • RE: Create accumulated chart

    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.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Create accumulated chart

    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?

  • Nithya Gopinath Profile Picture
    Nithya Gopinath 17,076 on at
    RE: Create accumulated chart

    Hi Jonathan,

    Refer the community thread below.

    community.dynamics.com/.../167988

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,979 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,848 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans