Dynamic Graphing in Excel (DEMO)
Originally published: 23/07/2019 08:03
Last version published: 31/10/2019 09:59
Publication number: ELQ-49256-10
View all versions & Certificate

Dynamic Graphing in Excel (DEMO)

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

NOTE: An UNLOCKED version of this model can be purchased 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

ExcelModels offers you this Best Practice for free!

download for free

Add to bookmarks




More Best Practices from ExcelModels

See all

Any questions on Dynamic Graphing In Excel (DEMO)?

The user community and author are here to help. Go ahead!

4.9 / 5 (8 votes)

please wait...