Changing the Layout of the Chart from Rows to Columns and Vice Versa in Microsoft Excel

When you create a chart, Excel checks the number of rows and columns. In the example below, there are six rows (in Column A, Zone) and three columns ...

Preventing charts from being printed in Microsoft Excel

Select a chart, and right-click. From the shortcut menu, selectFormat Chart Area. Select the Properties tab, and clear the checkbox beside Print O...

Printing a Chart in Microsoft Excel

In this article, we are going to learn how to print a chart in Microsoft Excel. Before learning how to print a chart, we should know about few things...

Setting the Default Chart Type in Microsoft Excel

You can change the default chart type by pressing F11 or by selecting a different chart type from the Chart toolbar. Select a chart sheet or selec...

Shortcuts to see the Help for the Syntax Function in Microsoft Excel

Experienced Excel users prefer to type formulas directly into a cell, in the formula bar. This is a good technique for skilled users who are familiar ...

Changing the Default Date Separator from a Slash to a Dot When Entering a Date into a Cell

Excel recognizes a number as a date by its date format, which uses a slash (/) as a separator, for example, 1/25/2004 is recognized as a date by Excel...

Displaying the Serial Number Behind the Date

Excel handles dates and times numerically. The numbers for dates range from 1 to 2958465, with 1 indicating January 1, 1900, and 2958465 indicating De...

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.