Chart Formatting Pane Missing

Question

I've created a chart in Excel 2013, and have attempted to format the axis. I have selected and right clicked the axis, then clicked 'Format axis'. However, nothing happens, the formatting pane just doesn't pop up.

This happens on all my spreadsheets now, but I know it used to work fine. The formatting pane doesn't open if accessed through the ribbon either.

Any ideas on how I can get it back?

Megan

Answer 1

Hello,

I'm struggling with the same problem here... I'm trying just to change the axis scale but nothing happens when I right click the option... 

Just to let you know, I've tried all sort of codes on VBA screen, turned off all add-ins and I'm still stuck in the same problem..

Answer 2

Hi Megan,

You may follow these steps and check if you can open the Formatting Task Pane:

Click on Axis, on the ribbon click Format.

Click Format Selection and check if the formatting task pane opens.

If the issue persists, then you may open Excel in its application safe and check if the issue occurs:

Click Start, go to Programs, go to Accessories, click Run, type excel /safe (note there is a space between excel and /).

If the application works fine safe mode, try disabling the add ins for the application and check the result,

• Click the File tab.
• Go to Options.
• Click Add-ins.
• Clear all the options.

If the above steps does not help, then you may repair Office 2013 following the steps from the article below:

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

If that still does not help, then change the default printer to Microsoft XPS Document Writer/OneNote following the steps from the link below:

http://windows.microsoft.com/en-US/windows7/Change-your-default-printer

If you are able to print properly on Microsoft XPS Document Writer or OneNote, then you may have to update your printer drivers or contact the printer manufacturer for further assistance.

Let us know if the suggestions provided is helpful.