Excel

Column chart on two separate axes for Excel

Column chart on two separate axes for Excel A column chart on two separate axes allows you to scale one side differently from the other. Requirements Microsoft Excel 2007 or higher or compatible. Download Chart library  Excel Effects home Charts As you may know, charts help you show data and information to your audience in […]

Column chart with average line for Excel

Column chart with average line for Excel The column chart with average line is a very common chart in many companies. It is a combination chart, just with an average line, going straight across the series. Requirements Microsoft Excel 2007 or higher or compatible. Download Chart library  Excel Effects home Charts As you may know, […]

Column chart with scatter line chart for Excel

Column chart with scatter line chart for Excel The column chart with scatter line chart for Excel is also known as a combination chart. Requirements Microsoft Excel 2007 or higher or compatible. Download Chart library  Excel Effects home Charts As you may know, charts help you show data and information to your audience in a […]

Dynamic yearly calendar for Microsoft Excel

Requirements: To use the dynamic yearly calendar, you need Microsoft Excel 2007 or higher or compatible. Download The dynamic yearly calendar The dynamic yearly calendar is an Excel tool that allows you to select a year from 1900 to 2400. When we first developed this tool, everything was going great. However, it did not work […]

EFFECT worksheet function for Excel

The EFFECT worksheet function for Excel returns the effective annual interest rate. EFFECT worksheet function Below is the syntax of the EFFECT function. Syntax =EFFECT(Nominal_rate, Npery) Arguments Here are the arguments of the EFFECT function. Argument Description Nominal_rate The nominal interest rate. Npery The number of compounding periods per year. Examples Example 1 Note: For […]