Excel 2007 : Analysis Toolpak Histogram crashing Excel

Hi, I am attempting to create a histogram using Analysis Toolpak in Excel 07. Every time I choose the option "chart output", it causes Excel to crash. Does anyone know why it's doing this?

Hi,

I had the same problem with you but i solve it with the below steps. Although i not sure which steps correct the problem

- Install the latest update from Microsoft, use window update.
- Disable the Analysis Toolpak and then close all your open excel file, and then go through the process to enable your Analysis Toolpak again.

http://support.microsoft.com/kb/312833

Good luck.