Dynamic Stacked Chart - How to help please...

[PaulF]

Hello all!

I've attached a spreadsheet for Jan to Dec with 2 data points - Sales and Addons...

There are 2 Dynamic named ranges using offset functions based in a value being in the sales column to build out the chart...

I added a checkbox and can not figure out how to include addons as a stacked funtion with the checkbox is checked....

Any help in this matter would be much appreciated...

Respectfully,
PaulF

 

[Chihiro]

Here you go. You'd need to tie Addons with =IF($D$2=TRUE,Value,"") and change data selection for the chart to include it.

 

[PaulF]

Chihiro,

Thank you... I created a new dynamicRange called dynamicAddons and pulled that data from another location to make the chart dynamic again. This will work nicely in my setup

Thank you sir !!

Respectfully,
PaulF