Dynamic Graphing in Excel (DEMO)
  • Dynamic Graphing in Excel (DEMO)
  • Dynamic Graphing in Excel (DEMO)
  • Dynamic Graphing in Excel (DEMO)
  • Dynamic Graphing in Excel (DEMO)
  • Dynamic Graphing in Excel (DEMO)
  • Dynamic Graphing in Excel (DEMO)
  • Dynamic Graphing in Excel (DEMO)
  • 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
certified

Dynamic Graphing in Excel (DEMO)

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

Description
NOTE: An UNLOCKED version of this model can be purchased at:
https://www.eloquens.com/tool/rGKyI7G8/excelmodels/dynamic-graphing-in-excel-unlocked

● 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

Discuss

Reviews


keyboard_arrow_leftkeyboard_arrow_right

More Best Practices from ExcelModels

See all
keyboard_arrow_leftkeyboard_arrow_right

Any questions on Dynamic Graphing In Excel (DEMO)?

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


4.9 / 5 (7 votes)

please wait...