Dynamic Graphing in Excel (UNLOCKED)

Excel graphs that update and re-scale upon Pivot Table slicer click(s)

by ExcelModels
MBA, Finance professor & Excel masterFollow 156

280 views|Start the discussion!|Bookmark Add to cart - $19.00

Description
NOTE: A free DEMO version of this model can be found at:
https://www.eloquens.com/tool/xKB2SPvA/finance/excel-vba-tutorials/dynamic-graphing-in-excel-demo

● Dynamically rescales x-Axis for selected dates
● 4 bifurcated curves show A/B test results
● 27 graphs:  3 levels  x  3 metrics  x  (#,%,∆)

This model contains the following:
● Uses Dynamic Named Ranges to resize Horizontal Axis per selected date range
● Displays up to 4 'A' and 'B' color-coded curves (i.e. to show A/B test results)
● User can select from 2 levels of hierarchy (i.e. Department or Position)
● View temporal graphs for Positions(s), whole Departments(s), or the entire Company

Do NOT purchase this model unless you're an intermediate/expert Excel user with the patience to code & test. The under-the-hood architecture of this workbook is extensive, even though the results appear slick and simple.

The Dynamic Graphing model is a substitute for Tableau or other data visualization tools that require additional expense, learning, training, and support skills. A simple user selection of up to 3 different "column slicers" in a data table will immediately and without further input, re-scale and re-graph up to 4 different variables (i.e. curves).

Additionally, each curve depicts "before" and "after" plots for A/B Testing of any field in a broad dataset.

We also provide model customization and build-out on an hourly or project basis. Please contact us for more information. Thanks.

This Best Practice includes
1 Excel file