119 Powerpoint | How to use slides from another show?

en-usDecember 27, 2010

Daily Office Tips by Office ToDo

About this Episode

Go under Home tab into Slides section. Click on “New Slide” and choose Reuse Slides from the down appearing menu. On the right side of the screen appears a new menu. Click on “Browse” and select whether you want to browse slide library or files. Since we want to use slides from another show, we’ll browse the files. Click on the correct file and press on “Open”. Into the same right side menu a selection of slides used in the show appears. Click on the appropriate slide and notice how the slide appears into your current show. - Office ToDo

Recent Episodes from Daily Office Tips by Office ToDo

140 Excel | How to add, remove or reposition chart legend?

Click on the chart and go under Chart Tools and Layout tab. In Labels section click on “Legend” and from the appearing menu choose whether you wish for the legend to show in the first place, or the placement of it if you decide to show it on the graph. - Office ToDo

Daily Office Tips by Office ToDo

en-usJanuary 17, 2011

139 Excel | How to add, remove or reposition text used to label each axis?

Click on the chart and go under Chart Tools and Layout tab. In Labels section click on “Axis Titles” and from the appearing menu choose which axis you wish to edit. From the next selection determine whether you wish for the title to show up or not. Also choose the placement for the title if you decide to show it on the chart. Unfortunately no live preview is shown however you get a pretty good image of the display from the little picture before every selection. - Office ToDo

Daily Office Tips by Office ToDo

en-usJanuary 16, 2011

138 Excel | How to add a title to the chart?

Click on the chart and go under Chart Tools and Layout tab. In Labels section click on “Chart Title” and from the appearing menu choose the placement of the title. Notice that you can also remove the title under this menu. - Office ToDo

Daily Office Tips by Office ToDo

en-usJanuary 15, 2011

137 Excel | How to compare pairs of values?

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. - Office ToDo

Daily Office Tips by Office ToDo

en-usJanuary 14, 2011

136 Excel | How to emphasize differences between several sets of data over a period of time?

Best used for this is area charts. Select your table only including cells that you wish to be presented on the chart and go under Insert tab into Charts section. Under “Area” choose the type of areas that suit you best. Unfortunately no live preview is applicable in this case. - Office ToDo

Daily Office Tips by Office ToDo

en-usJanuary 13, 2011

135 Excel | How to compare multiple values on a chart?

Best used for displaying multiple values comparison is a chart with bars. Select your table only including the cells you wish to be presented on the chart and go under Insert tab into Charts section. Under “Bar” choose the type of bars that suit you best. Unfortunately no live preview is applicable in this case. - Office ToDo

Daily Office Tips by Office ToDo

en-usJanuary 12, 2011

134 Excel | How to display a contribution of each value to a total on a chart?

Best used for contribution display is a pie chart. Select your table only including the cells you wish to be presented on the chart and go under Insert tab into Charts section. Under “Pie” choose the type of the pie chart that suits you best. Unfortunately no live preview is applicable in this case. - Office ToDo

Daily Office Tips by Office ToDo

en-usJanuary 11, 2011

133 Excel | How to display trends over time on a chart?

Best used for trends is a chart with lines. Select your table only including the cells you wish to be presented on the chart and go under Insert tab into Charts section. Under “Line” choose the type of the line chart that suits you best. Unfortunately no live preview is applicable in this case. - Office ToDo

Daily Office Tips by Office ToDo

en-usJanuary 10, 2011

132 Excel | How to change the chart type?

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. - Office ToDo

Daily Office Tips by Office ToDo

en-usJanuary 09, 2011

131 Excel | How to compare values across categories on a chart?

Best used for such a comparison is the chart with columns. Select your table only including the cells you wish to be presented on the chart and go under Insert tab into Charts section. Under “Column” choose the type of the column chart that suits you best. Unfortunately no live preview is applicable in this case. - Office ToDo

Daily Office Tips by Office ToDo

en-usJanuary 08, 2011