Daily Office Tips by Office ToDo Office ToDo
-
- Tecnologia
Giving daily Office tips for Word, Excel and Powerpoint so you can be more effective and have better results. For older Daily Tips please visit our website www.officetodo.com
-
- video
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
-
- video
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
-
- video
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
-
- video
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
-
- video
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
-
- video
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