Office Solutions

How to Create a Dynamic Line Chart with Checkboxes in Your Excel Worksheet

If the line chart in Excel will refer to a lot of data and information, this chart will totally be in a mess. Hence, you can use the checkboxes to create a dynamic line chart in your Excel worksheet. Sometimes you will analyze a lot of data and information by just one line chart. However, all the information in one chart will interfere with your analysis. The image below shows a line chart that contains all the information. The effect of this line chart is actually very terrible. Thus,...

Read more »

How to Merge Multiple Workbooks to One Workbook via Excel VBA

When you need to collect information from other people, you will receive multiple Excel workbooks. And in this article, we will introduce the methods to merge multiple workbooks by using Excel macro. When you have received multiple workbooks, you will find it hard to manage those files. All the information is separate in those different files. In the image below, you can see that there are several workbooks. In each file, there are the sales volumes of this month. Now you need to input...

Read more »

2 Methods to Link Tasks with an Appointment in Outlook

Many users have the wish to link several tasks with an appointment in Outlook. In this article, we will focus on this issue and introduce 2 approaches. Sometimes, we indeed hope to associate task with appointment in Outlook. For example, we have an important appointment in our Outlook calendar. Before the appointment, we need to do some additional preparations. So we create several individual tasks for this appointment. At this point, we must wish to link these items. In response to this...

Read more »