Area Chart in Excel – Types, Inserting, Line vs Area, Correcting Chart
In one of our earlier blogs, we understood the usage of line charts in excel. In the line charts, the consecutive data points join to… Read Article
Pie of Pie Chart in Excel – Inserting, Customizing, Formatting
In the earlier blog, we learned the usage of a simple Pie chart in Excel. Pie of Pie Chart in Excel is a special case.… Read Article
Pie Chart in Excel – Inserting, Formatting, Filters, Data Labels
The Pie Chart in Excel is the most commonly used and simplest of the charts that are used in projects analysis. Let us think of… Read Article
100% Stacked Column Chart in Excel – Inserting, Usage, Reading
In our earlier blogs, we learned the usage of Stacked Column Charts. 100% Stacked Column Chart in Excel is its subset. The chart is useful… Read Article
Stacked Column Chart in Excel – Usage, Examples, Format, Special Gridlines
A stacked Column Chart in Excel is a great idea to visually represent the grouped data. In the earlier blog, we learned the usage of… Read Article
100% Stacked Line Chart in Excel – Inserting, Analyzing
In one of our earlier blogs, we learned the usage of Stacked Line Charts in Excel. 100% Stacked Line Chart in Excel is quite similar… Read Article
Column Chart in Excel – Types, Insert, Format, Clickable Chart
Charts in Microsoft Excel are used to visually represent the data. Column Charts are the most common and widely used charts, not only in Excel… Read Article
ISPMT Function of Excel – Interest Amount Keeping the Principal Constant
In our earlier blogs, we learned the usage of the IPMT Function to get the interest amount when the payment ( principal+interest ) was constant… Read Article
NPER Function in Excel – Calculating Number of Periods
When taking a loan, one must be willing to know how many payments will he/she have to pay in total to pay for the loan… Read Article
Format Chart Axis in Excel – Axis Options: Effects
In this blog, we will be formatting the chart axis effects by taking an example of a Line Chart in Excel. In a line chart,… Read Article
Make Your Own Chart Template in Excel
Chart Template in Excel is a time saver hack. Do you have to deal with charts in excel and have a fixed chart type, formatting,… Read Article
MIRR Function in Excel – Modified Internal Rate of Return
MIRR Function in Excel is a modified form of IRR. IRR considers that the money reinvests at the same discount rate. In finance, most of… Read Article