if statement - display chart with if function in EXCEL -


i creating reporting chart company , want make easy possible set reporting. struggling displaying charts in nice way. idea user writes 1 in cell a1, chart show @ position a20, if writes nothing not show.

my idea

if(a1=1;chart1;"")  

but unfortenatuly not work. know solution this?

thanks in advance

because chart object display, not object calculate.
think ideal can doing marco.

if cells(1, 1).value = "a 1"      'display chart in cell a20 else      cells(20, 1).value = "" end if 

Comments

Popular posts from this blog

php - Vagrant up error - Uncaught Reflection Exception: Class DOMDocument does not exist -

vue.js - Create hooks for automated testing -

Add new key value to json node in java -