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 y...
Radio and PodcastLive Radio & PodcastsTechnology
Daily Office Tips by Office ToDo
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
Episodes
20 of 50 episodes139 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 whic...
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...
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 Inse...
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...
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 presente...
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 u...
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 In...
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...
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...
130 Word | How to enable track changes?
Go to Review tab and under Tracking section click on “Track changes” to enable them. - Office ToDo
129 Word | How to delete a comment?
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 Revi...
128 Word | How to insert 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...
127 Word | How to toggle through Word documents opened at the same time?
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 docume...
126 Word | How to view different parts of my document 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 onc...
125 Word | How to have two Word documents open for editing in the same window?
First have those two documents open. From one document go under View tab and in Window section choose “Arrange All”. This way you’ll have tw...
124 Word | How to find a word in a Word document?
Go under Home tab into Editing section and press on “Find”. In the new window type the word you wish to find and click on “Find next”. - Off...
123 Word | How to easily replace words in a Word document?
If you need to replace a specific word in your document, press the button “Replace” under Home tab in Editing section. Under “Find what” typ...
122 Word | How to add straight lines to paragraphs?
The paragraphs work a lot like tables. Have your cursor in your selected paragraph and work around with the selections under Paragraph secti...
121 Word | How to sort data in Word?
In Word you can sort text, numbers and dates. Select your data and click on the button “Sort”, which is located under Home tab in Paragraph...