https://store-images.s-microsoft.com/image/apps.17859.81e051b5-ba53-4ead-b3c7-2f44c6763915.6fe62fb8-35c2-49fb-b56f-b95124e809fd.f565ca81-b86d-48cd-add8-b991bb204753

3AG Systems - Line chart with absolute variance

by 3AG Systems

(3 ratings)
Download SampleInstructions

Automatically calculates absolute variance and displays data in a line chart with the variance on to

Line Chart with Absolute Variance takes two datasets and automatically calculates the absolute variance between the two data. It plots the two datasets in a line chart and shows absolute variance on top of the line for each category. The visualization is influenced by the International Business Communication Standards (IBCS) where colors red and green are used to flag the bad and good indicators respectively. Customization options include: inversing the colors for red and green; resizing the data label font sizes; hiding data labels; increasing or decreasing decimal places; adjusting value to thousands (K), millions (M), and billions (B); drilling-down hierarchical data; adjusting number of characters to show on x-axis labels ; rotating x-axis labels for clarity; hovering capability to show full text for truncated x-axis labels and more. This chart is useful to compare “Actual vs. Planned”, “Actual vs. Previous Year”, “Forecast vs. Planned”, and “Forecast vs. Previous Year” data.

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.13490.81e051b5-ba53-4ead-b3c7-2f44c6763915.6fe62fb8-35c2-49fb-b56f-b95124e809fd.78966fb5-a443-4857-b74a-41508896da50
https://store-images.s-microsoft.com/image/apps.28699.81e051b5-ba53-4ead-b3c7-2f44c6763915.6fe62fb8-35c2-49fb-b56f-b95124e809fd.775eebb8-5dcb-4194-a22f-5d96aaa14648
https://store-images.s-microsoft.com/image/apps.28299.81e051b5-ba53-4ead-b3c7-2f44c6763915.6fe62fb8-35c2-49fb-b56f-b95124e809fd.8221493a-8995-4b8f-ad6a-2c223acd1006
https://store-images.s-microsoft.com/image/apps.41795.81e051b5-ba53-4ead-b3c7-2f44c6763915.6fe62fb8-35c2-49fb-b56f-b95124e809fd.ecdb0653-7318-4843-82ba-debd893e3bc5