Solutions

3 Ways to Add an Average Line to Your Charts in Excel (Part II)

In the former article, we have discussed about adding horizontal line into the chart. Thus, in this article, the method to add vertical average line to horizontal chart will be displayed. Sometimes, you will need to create a horizontal bar chart. So the average line should be vertical. Add Vertical Average Line to Horizontal Chart Select the target area. Click the “Insert” in the tab. Then click the button “Column”. In the drop-down menu, click the “All-Chart...

Read more »

3 Ways to Add an Average Line to Your Charts in Excel (Part I)

Chart in Excel are always used to analyze some important information. Therefore, in this article we will demonstrate how to add horizontal average line to vertical chart in Excel. In an Excel worksheet, you will always add a chart according to the data in certain cells. And sometimes, you will need to know the average level of certain index. For example, in this image, you can see that there is a bar chart for the sales volume of those sales representatives. However, the average level is...

Read more »

How to Remove Duplicate Recipients from Your Outlook Emails

When selecting multiple contact groups in “To” field of an Outlook email, duplicate recipients may occur because some contacts exist in several groups simultaneously. This article will teach you how to remove the duplicate recipients. When I send an Outlook email to several contact groups, some recipients ask me why I send several same emails to them. Since then, I noticed that their email addresses exist in the groups simultaneously. Thus I accidentally send duplicate emails to them. In...

Read more »