Excel 2016 2013 2010 2007 2003

Preventing objects from being printed or why objects aren't printing

Using the standard Excel tools, you can prevent access to the workbook or protect it from editing. Protection of a sheet from editing does not forbid printing, for example, to a PDF file.

Customize the vertical axis labels

Excel provides very few options for formatting vertical axis labels. All axis labels are a single object - you can change the font size and color or apply effects to all labels at the same time. Even the gradient fill with the color of the axis labels works for us as for the whole item and not for individual objects.

Customize the horizontal axis labels

Excel provides very few options for formatting horizontal axis labels. You cannot format different axis labels with different colors or font sizes. Conditional formatting also only works in some cases. You need to implement some tricks to format the horizontal axis, for example:

How to add an axis pointer

Since our school times, we became familiar with drawing charts with arrows on the axes, but in Excel charts, the axes are just lines. You can customize them differently: change their width, color, and transparency; hide any axis or its labels; add the secondary horizontal or vertical axis; add, hide, or display a part of axes labels; etc.

How to change axis labels order in a bar chart

Excel can display the data series in an inconvenient order for bar charts. For example, if you have a table with tasks for a Gantt chart, after creating a bar chart (see how to create a simple Gantt chart for more details), you expect to see tasks on the list arranged from top to bottom. Unexpectedly, Excel displays them in the reverse order:

How to freeze charts, shapes, text boxes, and other objects in Excel

Numerous users face a problem when, after inserting, deleting, and resizing some cells on a spreadsheet, Excel changes the dimensions of a chart, the position of a shape or image, etc. Objects in Excel are positioned on the drawing layer that covers cells on a worksheet.

Power trend equation and forecast

If you have data with only positive values that show a steady increase or decrease with a fixed rate of growth or decline, use the power trendline. See more about the different types of trendlines you can create in Excel:

Polynomial trend equation and forecast

If the data set is large enough and the data alternately increases and decreases, fluctuates - go up and down, the best type of trend line is polynomial. However, keep in mind that the polynomial trend is intended to describe the current data set and calculate the values within it. It is not intended for making predictions at all. See more about the different types of trendlines you can create in Excel:

Logarithmic trend equation and forecast

If the growth or decay of the data first rapidly accelerates and then slows down over time, the best type of trend line is logarithmic. See more about the different types of trendlines you can create in Excel:

Exponential trend equation and forecast

If the data is strictly positive and increases or decreases rapidly with a constantly increasing rate, the best type of trend line is exponential. See more about the different types of trendlines you can create in Excel: