You want to draw a column chart with two data series and one you want to make a primary and one you want to make secondary. Below, you have drawn a normal column chart in first chart. The second series (orange one), you have converted to secondary axis. Now, it has overlapped the first series….
Author: Vijay A. Verma
Article 23 – Correcting Excel (MS Office) Errors Post Windows 10 Upgrade
Last Updated – 29-Sep-15 Arrival of Windows 10 is something which everybody waited for and users had been loving it. But few users have been experiencing problems with MS Office and particularly with Excel post upgrade to Windows 10. Since, Excel is one of the most important productivity tools which all of us use every…
Challenge 23 – Make Bar Chart to Show Performance
This time challenge is to create a bar chart like below to show the Target Planned and Target Achievement. Related Excel you can download here Salesman Performance Challenge You may post your solution in comments section. Note – Solution to this challenge will be published after 1 month i.e. on 14-Sep-15.
Article 22 – Detect corruption of MS Excel worksheet and Recover it
— This post is contributed by Priyanka Chauhan of Stellar Info. This is not an endorsement of the product on behalf of eforexcel.com — Microsoft Excel is used worldwide majorly for business purposes. It is the simplest tool which helps in maintenance of records, timelines and tasks in a table based format. Most of us…
Solution – Challenge 20 – Find Number of Friday the 13th between Two Given Dates
Below is a possible solution to the challenge – Challenge 20 – Find Number of Friday the 13th between Two Given Dates The formula for finding this would be – =SUMPRODUCT((TEXT(ROW(INDIRECT(A1&":"&A2)),"ddd")="Fri")*(TEXT(ROW(INDIRECT(A1&":"&A2)),"dd")="13"))
Tips & Tricks 104 – Hide a Sheet Securely
You want to hide a sheet so that nobody else can open that. This may arise in some situations like you have a dump of employee data which has sensitive information like salary, last rating, age etc. You want to keep a copy of this in your workbook but you want to refer to only…
Tips & Tricks 103 – I need to fill in A-Z or a-z very often. What to do
1. Put =CHAR(96+ROW()) in cell A1. 2. Drag down till A26 to generate a to z. 3. Put =CHAR(64+ROW()) in cell B1. 4. Drag down till B26 to generate A to Z. 5. File > Options > Advanced > Go down till you find Edit Custom Lists (You have to go down till bottom) and…
Excel Quiz 18
Tips & Tricks 102 – How to Find all Links in an Excel Workbook
Rogue links troubling your workbooks. You have visually inspected them and still you have no clue where to find them, then read on… Approach 1 – Easiest Approach Bill Manville offers a free Add-in which finds all links given in your Excel. The utility is a very popular one and it should be must have…
Article 21 – Clipboard Error in Excel – We couldn't free up space on the Clipboard
Many times when working in the Excel following errors may be encountered – > We couldn't free up space on the Clipboard. Another program might be using it right now > The clipboard cannot be emptied. Another program might be using the clipboard