3AG Systems - Bar Chart With Relative Variance

by 3AG SystemsMicrosoft 365Paid

Generates overlapping bar and lollipop charts showing percentage variance between two scenarios.

Facts verified marketplace.microsoft.comAd-free rankings
PRICINGPaid
DEPLOYMENTCloud
CATEGORYAnalytics
UPDATED ON MARKETPLACE
3AG Systems - Bar Chart With Relative Variance — screenshot from the Microsoft Marketplace listing

What it does

Calculates percentage variance between two scenarios and displays it in an overlapping bar chart with a parallel lollipop chart. It supports comparisons such as actual versus planned, actual versus previous year, forecast versus planned, and forecast versus previous year. Chart options include red and green color inversion, data-label sizing or hiding, category drill-down, unit changes, and formatting influenced by International Business Communication Standards.

Key capabilities

from the Microsoft Marketplace listing

Percentage variance calculation

Calculates relative or percentage variance between two scenarios.

Overlapping bar chart

Generates an overlapping bar chart that displays relative variance.

Parallel lollipop chart

Places a lollipop chart alongside the bar chart.

Chart customization

Provides options for color inversion, data-label font sizing, data-label visibility, category drill-down, and display units.

IBCS-influenced formatting

Uses formatting influenced by the International Business Communication Standards.

Use cases

  • Comparing actual results with planned values.
  • Comparing actual results with the previous year.
  • Comparing forecast values with planned values.
  • Comparing forecast values with the previous year.

In the catalog

2,531 plugins in Analytics

Price distribution: 125 free, 147 freemium, 1,350 paid, 909 price not published

Pricing & deployment

Platform
Microsoft 365
Deployment
Cloud
Pricing
Paid

More from 3AG Systems

Similar plugins in Microsoft 365 · Analytics

View all 2,531 →

What the vendor says

«Bar Chart with Relative (%) Variance automatically calculates relative or percentage variance between two scenarios and generates an overlapping bar chart that displays the relative variance with a lollipop chart situated parallel to the chart. The visualization is meant for comparing Actual, Forecast, Planned, and …»

Official marketplace listing

Publisher
3AG Systems
Updated on marketplace
Facts verified

Tags

3agsystemsbarchartwithrelativevariance