Change Chart Type by Cell Text

[Jenbot]

Hello,

I am trying to change a bar graph into a line graph and vise verse by only typing the words "column" or "line" into a single cell. Does anyone know how to do this?

 

[Hui]

Jenbot

Firstly, Welcome to the Chandoo.org Forums

Have a look at the technique shown in this post:
http://chandoo.org/wp/2013/04/23/interactive-chart-in-excel-tutorial/