If you get prompted that the Solver Add-in is not currently installed on your computer, you will be prompted. Click Yes to install it. Now read : How to use Data Visualizer Add-In for Excel .