Changing Chart Titles causes Excel Shut Down

**janetlyn** · 03-24-2009, 10:59 AM

I have an excel 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 only found one other person on google with this issue and the answer was blocked. I cannot find any issues dealing with graph titles in the Knowledge base at Microsoft. I need to get this graph done but cannot do much if I cannot even change the title.

Any suggestions please? Thanks, JL

**Andy Pope** · 03-24-2009, 11:41 AM

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"

Have you tried converting the file to xl2007 format?

**janetlyn** · 03-24-2009, 12:08 PM

Following your instructions I get the following:

Compile Error: Invalid use of property

Copying and pasting here what is in the immediate window

Activechart.charttitle text = "Billings by Clients - 2009"

Yes, that was one of the first things I looked at. And just in case converting didn't work, I completed 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.

It is sooooo frustrating. Of course, it doesn't help that my Access DB is also having conversion problems so I am dealing with that while waiting for help on this. What a fun Tuesday. Anymore suggestions? Appreciate your help, JL

**Andy Pope** · 03-24-2009, 12:43 PM

you have missed a dot between charttitle and text

**janetlyn** · 03-24-2009, 12:48 PM

It is a good thing I can claim that I have bad eye problems. I actually see dots everywhere, so I am surprised I missed that one.

It worked. You are an angel. May God bless the rest of your day.

JL

**janetlyn** · 03-25-2009, 02:58 PM

I now need to know how to change the title for the primary vertical axis because it is also kicking me out of excel when I try to type in a title. Is this a bug, or what?

I have tried in the immediate window, the following, to no avail:

Activechart.axistitle.text = "$ (in thousands)"
Activechart.verticaltitle.text = "$ (in thousands)"
Activechart.verticalaxistitle.text = "$ (in thousands)"
Activechart.primaryverticalaxistitle.text = "$ (in thousands)"

Help please?

**Andy Pope** · 03-26-2009, 05:09 AM

Please Login or Register  to view this content.

**janetlyn** · 03-26-2009, 10:17 AM

Thank you Andy

I would test it, but now if I open Excel and my worksheet and then click on ANY graph title, just to choose it, not typing anything, it automatically shuts Excel down.

Suggestions please?

JL

**Andy Pope** · 03-26-2009, 10:26 AM

Sounds like you workbook is really corrupted and rebuild maybe the only way forward.

You could try openning it in a previous xl version

Or you might have some luck openning it with OpenOffice

**janetlyn** · 03-26-2009, 11:17 AM

I can open the workbook. I can click anywhere on the screen or do whatever I need to, to the workbook. However, if I click on one of the graphs titles, it automatically shuts down excel.

**Andy Pope** · 03-26-2009, 11:24 AM

If the workbook with data only is stable then maybe you will only have to rebuild the chart(s).

Not sure what else I can add.

**janetlyn** · 03-26-2009, 11:31 AM

Seems to be everyone's reply. I have deleted the chart and created a complete new one. Everything is fine and I can collect the data, format the chart to my liking, but the minute I click on one of the titles it kicks me out.

Excel is not my friend today. HA. Have a wonderful day and thanks for your help.

**Andy Pope** · 03-26-2009, 11:36 AM

I would also try copying the data to a brand new workbook.

Have you tried Office Diagnostics?
Office button > Excel Options > Resources > Diagnostics

Changing Chart Titles causes Excel Shut Down

LinkBack

Thread Tools

Rate This Thread

Display

Changing Chart Titles causes Excel Shut Down

Re: Changing Chart Titles causes Excel Shut Down

Re: Changing Chart Titles causes Excel Shut Down

Re: Changing Chart Titles causes Excel Shut Down

Changing Chart Titles causes Excel Shut Down

Re: Changing Chart Titles causes Excel Shut Down

Re: Changing Chart Titles causes Excel Shut Down

Re: Changing Chart Titles causes Excel Shut Down

Re: Changing Chart Titles causes Excel Shut Down

Re: Changing Chart Titles causes Excel Shut Down

Re: Changing Chart Titles causes Excel Shut Down

Re: Changing Chart Titles causes Excel Shut Down

Re: Changing Chart Titles causes Excel Shut Down

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions