Free Dynamic Horizon Chart with Series Toggle for Excel
Latest Update: 18.10.2018
Free Direct Download:
https://www.kubiszyn.co.uk/download/f...
This is my Dynamic Horizon Chart with Series Toggle for Excel. You can view any Horizon in your data Range by Selecting the Horizon Start and End Buckets. You can Toggle Series on/off using the Check boxes. Adjustments to this Worksheet are fairly straightforward as there is no VBA Code. The Dynamic Chart works by referencing a copy of the data using Formula which also prevents Blank values from being plotted on the Chart. Other settings are used by 6 Defined Names, 1 for the Horizon Buckets and then 5 more, 1 for each Series of data. These Defined Names use a Cell Start Reference, the number of Columns wide (X-Offsets) and an Offset for the Series position (the Y-Offset). You can add more or remove Series with minor modifications to the Worksheet
FEATURES
select any Horizon to display the buckets dynamically on the Chart ie. M 01.2015 - M 12.2018
toggle any of the Chart Series on/off using Check boxes
Paste new data in Quarters, Weeks or Days with only minor modifications to the Worksheet
add/remove Series with only minor modifications to the Worksheet
REQUIRED
Excel 2010 or Excel 2013 (32 bit or 64 bit), working with Windows 7 & 10
Knowledge of Excel Formula and Named Ranges (Defined Names) if you want to develop this for other Projects. You can Copy & Paste your own data with minor adjustments to the Worksheet and you are good to go