vendredi 28 juillet 2017

display chart with if function in EXCEL

I am currently creating a reporting chart for my company and i want to make it as easy as possible to set up this reporting. Currently I am struggling with displaying charts in a nice way. My idea is that the user writes a 1 in say Cell A1, then a certain chart will show up at position A20, if he writes nothing it will not show.

My idea was something like

if(A1=1;Chart1;"") 

but unfortenatuly it does not work. Does anybody know a solution to this?

Thanks in advance

Aucun commentaire:

Enregistrer un commentaire