This is a monthly sales variance Excel template that analyses trends over time by comparing the actual (AC), previous year's (PY), and planned data (PL) in the same chart. It features automatically calculated variances presented in a horizontal variance chart, together with dynamic comments for more information.
Features used
Actual data display with up to 2 comparisons
Monthly & year-to-date views for a greater insight
Dynamic comments
Automatically calculated variances
Custom calculations
Present your monthly sales in the form of an actionable story. Enjoy the preview of how Zebra BI for Office turns your data into concise and compelling insights.