If you have for some reason chosen an inappropriate type of chart, you can easily change it. First select the chart and go under Chart Tools and Design tab. From there the very first button on the ribbon is called “Change Chart Type”. Click on it once and you’ll be able to try again with hopefully a more suitable chart type for you.
Continue readingAuthor Archives: Karl
How to see bottom ten percent of items on the list? | Excel 2007
First select your cells and go under Home tab into Styles section. Choose the first button from the row called “Conditional Formatting”. From there choose “Top/Bottom Rules” and “Bottom 10 % …” In the menu you can choose the percentage to be reached. By default the number is 10. From the right sided drop-down menu select the style you wish to apply. Notice that some only apply to text or background whilst others format both of those. If you are satisfied, click on “OK”. Remember that this percentage does not come from total value of the list, but from the bottom values forming 10% in terms of items.
Continue readingHow to increase the space between default bullets and text on a slide? | Powerpoint 2007
Perhaps the easiest way in case of long lists is to use the ruler. If not present on your default view, go to the Ribbon under View tab and Show/Hide section. Tick in front of Ruler. Now on the slide drag the starting point of text in following the bullet.
Continue readingHow to compare pairs of values? | Excel 2007
Best used for this is the scatter chart. Select your table only including cells that you wish to be presented on the chart and go under Insert tab into Charts section. Under “Scatter” choose the type of scatter that suits you best. Unfortunately no live preview is available on this case.
Continue readingHow to group the placeholders on the slide? | Powerpoint 2007
Unfortunately those placeholders themselves cannot be grouped. One option would be to add real text boxes on top of those placeholders. Keep in mind to have those boxes over the placeholders in order to be able to select them.
Continue readingHow to adjust the contrast of an image? | Powerpoint 2007
Go under Picture Tools and Format tab under Adjust section and click on “Contrast”. From the down appearing menu choose the appropriate level that suits you most. Since live preview is shown, the selection should be easy to make.
Continue readingHow to copy formatting? | Excel 2013
Click on the cell from which you would like to copy the format. Go to home tab and Clipboard group. Select format painter. Click on the cells to copy the format.
Continue reading