Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM (Archived)

Can I create a dynamic graphic whitout utilising Excel ?

Posted on by Microsoft Employee

Hello :) I am a newbie at using Microsoft Dynamics CRM so i am asking maybe a really light question but can we create dynamic graphics (like bar charts etc...) without extracting de data to Excel and doing the calculus, formulas all in the Microsoft Dynamics CRM without any extraction to Excel ? I really thank you for the help ! Sorry for my english, i'm french ... ^^

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Can I create a dynamic graphic whitout utilising Excel ?

    Thanks a lot for your response :) !

  • Suggested answer
    Tom Fursdon Profile Picture
    Tom Fursdon on at
    RE: Can I create a dynamic graphic whitout utilising Excel ?

    Short answer is no, unfortunately.

    Charts in CRM are a visual representation of a view.

    If you have queries that you use often, you could make a view for each one and use the view selector (the chart would update based on the currently selected view), though this doesn't come close to the functionality of Excel's pivot tables.

    CRM does give you the option to export data to an Excel pivot table from a view. If you have CRM for Outlook installed, then the data in the table will update inside Excel, from CRM.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Can I create a dynamic graphic whitout utilising Excel ?

    In other words, i want to create pivot tables directly into the CRM. Is it possible ?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Can I create a dynamic graphic whitout utilising Excel ?

    Thank you for the answer ! But my question was more about things like Excel Pivot Table... Can we use them inside the CRM without extracting the data to Excel for exemple... The basic graphs I know how to create them already :) Thanks a lot

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Can I create a dynamic graphic whitout utilising Excel ?

    You can create charts in CRM. Go to Settings->Customization->Customize the system. Open the entity for which you want to create the chart. Then go to the charts section and create a new chart. Check this link for more details

    crmbook.powerobjects.com/.../charts-4

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Can I create a dynamic graphic whitout utilising Excel ?

    Up :D

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans