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

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 “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

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 “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

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

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

137 Excel | How to compare pairs of values?

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

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

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

135 Excel | How to compare multiple values 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

134 Excel | How to display a contribution of each value to a total 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

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

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

132 Excel | How to change the chart type?

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

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

Go to Review tab and under Tracking section click on “Track changes” to enable them. - Office ToDo

130 Word | How to enable track changes?

Right click on the bubble and choose “Delete Comment” from the menu. In case you wish to delete all comments in your document, go under Review tab and under Comments section. From there choose “Delete” and “Delete all comments in document”. - Office ToDo

129 Word | How to delete a comment?

Select your text or part of the text you wish to comment and go to Review tab. Under Comments choose “New Comment”. To the right side of the document a bubble appears. Into this you can leave your comments. - Office ToDo

128 Word | How to insert a comment?

One way, if you prefer not going to the taskbar, is to go under View tab and Window section. Click on “Switch Windows” and choose the document. - Office ToDo

127 Word | How to toggle through Word documents opened at the same time?

Go to View tab under Window section and press on “Split”. You’ll get an opportunity to place the point where the split is created. Click once and a split is placed. Now you can view and edit two parts of your document simultaneously. - Office ToDo

126 Word | How to view different parts of my document at the same time?

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

hubhopper

Daily Office Tips by Office ToDo

hubhopper