Dynamic Graphing in Excel (UNLOCKED)
Originally published: 24/07/2019 09:02
Last version published: 08/08/2019 20:39
Publication number: ELQ-84916-4
View all versions & Certificate

Dynamic Graphing in Excel (UNLOCKED)

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

NOTE: A free DEMO version of this model can be found at:

● 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

Acquire business license for $19.00

Add to cart

Add to bookmarks


0.0 / 5 (0 votes)

please wait...