Creating a bar chart with average sector spend overlay

(1) Share

Report

Posted on by Community Member

Hello everybody,

Would it be possible to create a bar chart to show the product spend for a customer with the average sector spend overlaid. In effect, the bar chart would show the annual spend on product X, Y and Z. The average line would total the sector spend across the same categories, so that gaps can be identified. Hopefully the graph would be interactive and we could drill down into each category to see the same graph, but for product families, and then further to see product variants.

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (1)

Community Member on at

Like (1)

Report

RE: Creating a bar chart with average sector spend overlay

Bump of the thread just to see if anybody might have an idea on this? The only thing I can imagine is just two separate graphs next to each other as I can't see a way to do an overlay like this.

Thanks.

Was this reply helpful? Yes No
Suggested answer

Siraj M on at

Like (0)

Report

RE: Creating a bar chart with average sector spend overlay

check if this combo chart works for you

Regards,

Siraj

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Creating a bar chart with average sector spend overlay

[deleted]

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report

RE: Creating a bar chart with average sector spend overlay

Thanks. I found another way through one of my colleagues:

Use Power Bi integrated with Dynamics. Create a line and clustered column chart graph and display it within the Dynamics CRM dashboard.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Creating a bar chart with average sector spend overlay

Mahesh,

A community is for sharing info and answers rather than trying to sell your services. Maybe something you should consider going by some of your replies to questions.

Was this reply helpful? Yes No