Charts: Show field from a related record...i.e. Account(Industry code) and Opportunity(Est. Revenue)

Charts, charts and more charts!

How do you create a chart like the one below(2 fields from 2 entities)

Normally when creating charts you can only select fields on the current entity or primary lookups!

So what do you do:

Export the xml and make one tiny change and import it back in.

http://blog.simonjackson.info/2012/12/crm-2011-charts-group-by-any-related.html

In example below the chart was created using opportunities, the fields Est. Revenue & Potential Customer.

Edit the xml for potential customer i.e. customerid to industrycode

Import back in viola!

Other things you can do:

Scale break http://blogs.msdn.com/b/crm/archive/2011/05/02/crm-2011-charts-know-the-real-potential-part-deux.aspx

Bar Chart and Data Points - http://blogs.msdn.com/b/crm/archive/2011/01/04/crm-2011-charts-know-the-real-potential-part-i.aspx

 

3D - http://niiranen.eu/crm/2010/10/turn-the-flat-dynamics-crm-2011-charts-into-3d/