Archive for the ‘Microsoft Office Excel’ Category
Thursday, February 9th, 2012
Data labels are what you use to indicate what the main part of your chart represents. Labels can mean quite a lot depending on the sort of chart you have created.
If you are creating a pie chart for example, your data may be more difficult to understand if you do not use data labels.
Follow the steps below to add data labels:
Version 2007 -2 010:
- Activate your chart by clicking on it, if necessary.
- Be certain the Layout tab of your Ribbon is displayed.
- Click the Data Labels tool and Excel will display options that will control where your data labels are positioned.
- Select the position that will best fit where you would like your labels to appear.
In older versions:
- Click on your chart to activate it, if necessary.
- Select Chart Options from the Chart menu and Excel will display the Chart Options dialog box.
- Be certain the Data Labels tab is selected.
- The left-hand side will show the different data label options available to you.
- There are five different basic types of data labels from which you can select (for a pie chart). Each of them represents a different combination of using the data value, percentage or a label as the actual data label.
- Select the option that best suits your situation.
- Notice that as you make your selections, the preview chart will be updated.
- Click OK.
Your chart has now been updated to your liking.
Tags: activate, box, Chart, data. labels, dialog, layout, Ribbon, tab
Posted in Excel 2003, Excel 2007, Excel 2010, Microsoft Office Excel | No Comments »
Tuesday, February 7th, 2012
Follow the steps below to learn how to hide and unhide rows:
- To hide your rows, select a cell(s) in the row(s) you would like to hid and click CTRL + F9.
- To unhide your rows, select a range of cells to the bop and bottom of the hidden row(s) and click CTRL + Shift + F9.
Tags: cells, Ctrl, F9, hide, range, rows, shift, Unhide
Posted in Excel 2003, Excel 2007, Microsoft Office Excel | No Comments »
Monday, February 6th, 2012
This may seem to you to be a very basic tip but there are always folks out there who can benefit from this information and this is for them!
- To adjust your column width, select the column you want to adjust and simply drag the vertical bar between any two columns to the width that suits you.
- You can also double-click that same vertical bar and the columns will automatically fit to the widest entry in each column.
The same applies for adjusting row height in Excel.
- Select the rows you want to adjust and drag the horizontal bar between any two rows to the desired row height. If you double-click on that same bar, Excel will automatically adjust the rows to the best fit.
- If you want to have your column width adjusted based ont he widest entry in part of the column, select the area where you want the column width based on and click on Format | Column | AutoFit Selection.
Tags: bar, click, column, drag, height, horizontal, row, vertical, width
Posted in Excel 2003, Excel 2007, Excel 2010, Microsoft Office Excel | No Comments »