Jan 23, 2017 - (Note: This guest post is from Puneet Gogia at ExcelChamps.com. Puneet is a good friend of the blog, and today he shares how to build a panel.
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:
If that still does not help, then change the default printer to Microsoft XPS Document Writer/OneNote following the steps from the link below:
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.
Sometimes, instead of data labels that can easily obscure the data points in the chart, you’ll want Excel 2013 to draw a data table beneath the chart showing the worksheet data it represents in graphic form.
To add a data table to your selected chart and position and format it, click the Chart Elements button next to the chart and then select the Data Table check box before you select one of the following options on its continuation menu:
- With Legend Keys to have Excel draw the table at the bottom of the chart, including the color keys used in the legend to differentiate the data series in the first column
- No Legend Keys to have Excel draw the table at the bottom of the chart without any legend
- More Options to open the Format Data Table task pane on the right side where you can use the options that appear when you select the Fill & Line, Effects, Size & Properties, and Table Options buttons under Table Options and the Text Fill & Outline, Text Effects, and Textbox buttons under Text Options in the task pane to customize almost any aspect of the data table
The figure illustrates how a clustered column chart looks with a data table added to it. This data table includes the legend keys as its first column.
If you decide that having the worksheet data displayed in a table at the bottom of the chart is no longer necessary, simply click to deselect the Data Table check box on the Chart Elements menu.