Zum Hauptinhalt wechseln

3AG Systems - Line chart with absolute variance

3AG Systems

2.0 (1)

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.

Add-In-Funktionen
Hinweise für die Verwendung dieses Add-Ins:
  • Es kann Ihr Dokument lesen und Änderungen vornehmen.
  • Es kann Daten über das Internet senden.
  • https://az158878.vo.msecnd.net/marketing/Partner_21474848116/Product_42949682864/Asset_9d16f0c0-af56-4517-9355-2448d90ffb81/LineChartwithAbsoluteVariancep.png
    https://az158878.vo.msecnd.net/marketing/Partner_21474848116/Product_42949682864/Asset_9d16f0c0-af56-4517-9355-2448d90ffb81/LineChartwithAbsoluteVariancep.png
    https://az158878.vo.msecnd.net/marketing/Partner_21474848116/Product_42949682864/Asset_6fe1c017-b410-42e0-85c1-8331dc0e0ad7/LineChartwithAbsoluteVariancep.png
    https://az158878.vo.msecnd.net/marketing/Partner_21474848116/Product_42949682864/Asset_b6fdbfcd-69b9-40a0-99ea-8181c460c6b3/LineChartwithAbsoluteVariancep.png
    https://az158878.vo.msecnd.net/marketing/Partner_21474848116/Product_42949682864/Asset_042a05f0-9f1d-41e0-b1a4-965416df4877/LineChartwithAbsoluteVariancep.png