I have an excel (2007) spreadsheet with graphs on the same sheet. I have had them for 8 years. This month, when I went in to update the data (updating the
charts) I had to change the title on one of my graphs to say "Billings by Client - 2009" versus 2008. I clicked on the title, went to the end, backspaced, but the minute I typed in a '9', the error message showed up and I said, yes, notify Microsoft.
I have tried deleting the current chart title and then inserting a new title, which works fine, until I start typing inside the box with the new title. The minute I click on a letter, number, whatever, it gives me an error message, shuts down excel, reopens excel.
I was told to try this:
Do you get the same error if you try this code from the immediate window.
Select chart
ALT+F11 to go to VBE
CTRL+G to go to immediate window
enter the following and press enter.
Activechart.charttitle.text = "Billings by Client - 2009"
This worked and I moved on to further update my charts. I had to add a Primary Vertical Axis Title and the same thing started happening. Excel shuts down. I had converted this particular workbook from 2003 but thinking maybe that was the problem, I completely deleted one of my charts and created a
new one. The minute I tried to give the chart a title, it did the same thing, knocked me out of Excel. This time it did give me a message from Microsoft
saying they noticed I kept getting kicked off so they ran all these diagnostics and everything was fine. I tried running the above VB in the immediate window except where 'chartitled' was, I changed it to a myriad of possibilities (i.e. verticalaxistitle, primaryverticalaxistitle, verticaltitle, etc.) None worked. I have looked everywhere for the proper verbage to do this and cannot find it anywhere. So, that is something I need help with.
But mainly, I would like to know why Excel keeps shutting down. It has shut down two times today when I was not specifically doing something with a chart also, but it in not a repeating thing, so I cannot say exactly what I was doing at the time.
I cannot find anyone else having issues of Excel shutting when they were working on CHARTS, so I am hoping you can give me some suggestions?
Thanks, JL