https://store-images.s-microsoft.com/image/apps.41751.f42ad0dc-2fa9-4009-86eb-0653157c95f6.57bfc65e-dad3-4b2c-9d07-e8957663110c.5fd3a742-be15-4e22-9088-6dc2df468d33

Variance Chart

by Alexander Koch

Download SampleInstructions

Column or bar chart with absolute and relative variance

With Variance Chart you can create professional column charts or bar charts that show the difference between two measures, e.g. actual and target, as separate colored areas based on IBCS® (International Business Communication Standards).

Key features:

  • Choose from two different chart types - column or bar chart
  • Display percentages in additional lollipop chart
  • Drill functionality with visible hierarchy groups
  • Works with negative values
  • Meets certain IBCS® specific requirements (e.g. striped columns)
  • Individual indicator colors and reverse indicator
  • Various formatting options, e.g. column width, margins and color, label texts: font family, size and color
  • new:Value types that can be formatted individually, e.g. to highlight forecast periods
  • new:Additional invisible measure as alternative sorting option

Visual capabilities

When this visual is used, it
  • Can access external services or resources

At a glance

https://store-images.s-microsoft.com/image/apps.48123.f42ad0dc-2fa9-4009-86eb-0653157c95f6.f2817ac9-8540-4210-a64b-b98659e63d2d.1b764130-1ff3-4b25-bdcf-d7600bd475a5
https://store-images.s-microsoft.com/image/apps.2606.f42ad0dc-2fa9-4009-86eb-0653157c95f6.f2817ac9-8540-4210-a64b-b98659e63d2d.c33d1082-6497-4d48-a424-1a3307583ff6
https://store-images.s-microsoft.com/image/apps.6792.f42ad0dc-2fa9-4009-86eb-0653157c95f6.f2817ac9-8540-4210-a64b-b98659e63d2d.9e103b00-6765-40e3-bd7f-15bdc101a5e1
https://store-images.s-microsoft.com/image/apps.43447.f42ad0dc-2fa9-4009-86eb-0653157c95f6.a6b801d8-3469-4507-805d-0ba7473a8541.61e2fbea-2c79-4344-b570-6ed4b1cbcd56
https://store-images.s-microsoft.com/image/apps.15312.f42ad0dc-2fa9-4009-86eb-0653157c95f6.fab95ed1-681e-4d33-bb30-dc4344075cf5.237326f5-485c-474f-8fd2-c1e9dc78106c