You are currently browsing the tag archive for the ‘3D’ tag.

Yes, I have to say it, I don’t build charts too often. And because of that, sometimes it’s hard to remember how did I do it last time. Stacked charts is one of those examples. It’s been a few months since the last time I built one, and I just got asked a few questions that sent be back scrambling to figure out how to do it.

First off, what are stacked charts?

A stacked chart, looking like the image below, is a representation of parts in a whole. Very generically stated.

image

The chart describes the cases by origin for each day. So, the whole is the day, while the parts are the case origins. This could have been a single bar for the current day, or a set of bars for multiple days like the example shown.

So, now that we see the purpose, what available options do we have for representation?

Starting with the previous article HERE, we can adjust colors, labels, and other properties of the chart by modifying the XML. But let’s leave that as a last option, and look first at what we can do out of the box.

The example presented above shows a simple stacked chart. We can actually modify it to make it into a 100% Stacked Column chart. That is very easy to achieve by going to the chart properties, and changing the type of chart to 100% Stacked Column.

image

NOTE: You can not modify a default chart, you have to save it as new and then modify it.

image

The end result will look like the above screenshot. Of course, make sure that it makes sense to represent the data as such.

Now, pay attention to which charts support this functionality. Just like I mentioned above, making sure the data represented makes sense, some chart types do not make sense to have a stacked option. The ones supporting stacking are:

  • Column Type Charts
  • Bar Type Charts
  • Area Type Charts

Bonus Brownie Points

Editing the XML allows us to change this chart and show it in 3D. Export the chart XML, and find the <presentationdescription> tag. Underneath, locate the <ChartArea> and right before the closing tag of </ChartArea> add the following line:

<Area3DStyle Enable3D="True" LightStyle="Simplistic" />

Re-import the XML as a new chart. And now, your shiny new 3D chart will look like so:

image

Cool, eh? Now go ahead and stack’em high.

Enjoy!

Advertisements
MVP Reconnect

Check out my course [Video]

Dynamics 365 Customer Engagement Administration

Dynamics 365 Customer Engagement Administration

Check out my course [Video]

Configuring and Extending Dynamics 365 Customer Engagement

Configuring and Extending Dynamics 365 Customer Engagement

Check out my course [Video]

Getting Started with Dynamics 365 Customer Engagement

Reviewed Book

Implementing Microsoft Dynamics 365 for Finance and Operations

Implementing Microsoft Dynamics 365 for Finance and Operations

Reviewed Book

Microsoft Dynamics 365 Extensions Cookbook

Microsoft Dynamics 365 Extensions Cookbook

Check out my Book

Microsoft Dynamics CRM 2016 Customization - Second Edition

Microsoft Dynamics CRM 2016 Customization - Second Edition

Check out my Book

Microsoft Dynamics CRM Customization Essentials

Microsoft Dynamics CRM Customization Essentials

Check out my Book

Microsoft Dynamics CRM 2011 Scripting Cookbook

Microsoft Dynamics CRM 2011 Scripting Cookbook

Reviewed Book

Microsoft Dynamics CRM 2011: Dashboards Cookbook

Microsoft Dynamics CRM 2011: Dashboards Cookbook

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 608 other followers

Follow Dynamics 365 Wizardry on WordPress.com