Created an Excel workbook in c# but charting is disabled?

I have a c# application that generates an Excel workbook. The problem is that when you open the workbook and click on the "Insert" menu, "Chart" is disabled. Any idea on how to enable this option when creating the workbook in c开发者_开发知识库#?

I write this part taken from here.
Hope this helps...

Sounds like you have the setting to not display objects on the sheet (a chart is an object).
You probably can't add a rectangle, either!
Find the option in Office/Excel Options.
Or easier, press ctrl/6 (not F6, 6).
Bob Umlas
Excel MVP

EDITED:
Another solution taken from here.

Yes, the Shared workbook option will grey out the chart wizard.
You would have to remove the sharing to get the wizard back in that workbook.