Chart Title: Chart title is the main subject or topic that helps understand the main motive of the plotted chart.
#TUTORIAL FOR EXCEL 2013 SERIES#
The horizontal axis is also termed the Y-axis, and the series data can be combined on this axis as desired.
That is why it is also known as the Bridge Chart/Graph. Sometimes, the waterfall charts use different lines between columns in the plot area, which display a chart similar to a bridge. Values are reflected positively and negatively using different colours, showing how the value increases or decreases through a series of changes. However, all the columns together represent the whole value. In a waterfall chart, the first column usually represents the first value of the data series, while the last column represents the last value. This is an indicator of which row you are working on, and as with columns, rows will be automatically added to the sheet as you need them up to the maximum of 1,048,576 and are numbered from 1 onwards.The waterfall chart is a special type of Excel chart that mainly helps display the supplied data series’s beginning and ending position as per the change over time, either increasing or decreasing. They are numbered from A-Z, and after that AA, AB, AC etc. This is an indicator of which column you are working on, columns will be automatically added to the worksheet as you need them up to the maximum of 16,384 columns. If you don’t like the slider you can use the + and – buttons to do the same thing.
This slider allows you to zoom in to your document to see text etc in greater detail, or out to get a good overview of a large worksheet. Page Break view: This shows a preview of where pages will break when printed.Page Layout view: This display the pages exactly as they will appear when printed.Normal Layout view: This is the normal standard default view.This is a group of three buttons that allows you to switch between Excels three sheet views. This is the main work area of your spreadsheet and contains all the data, formulas, and labels that comprise your finished spreadsheet. The Status Bar displays useful information about your worksheet such the insertion point location and total number of pages amongst other things – right clicking the Status Bar will display a menu allowing you to customise what is displayed. This icon provides access to Microsofts built in help files, it also provides access to the online Microsoft help pages. Commands: These are the individual actions contained within each group such as Font Colour, Text Alignment, and Border Selection.Groups: These organise the related commands of a particular tab, Font, Alignment, and Number are all command groups, and the name of each group is displayed below the group.Tabs: These appear across the top of the Ribbon, and group related functions together, Home, Insert, Page Layout and Formulas are all examples of tabs.
The Ribbon contains all the commands used to manipulate your spreadsheet, and is broken down into three areas. Quick Access ToolbarĪs its name suggests, this is a toolbar which the user can customise to provide access to some of Excels most frequently used commands. Here is where you will find the Backstage view which is the place to access all the file related operations, and printing options as well as a whole bunch of settings and options. With the introduction of Office 2010 Microsoft replaced the Office button with the File tab, and this has continued with Office 2013. This area of the screen shows the name of the file you are working on, and which of the Office applications you are working in. When you start up Microsoft Excel 2013 for the first time you will be presented with a screen similar to the one below.īefore we start the tutorials in earnest we should look at all the main areas of the screen and how they interact with each other.