Create a Combination Chart, Add Secondary Axis in Excel [15 Second Tutorial]
Two most commonly asked or searched queries when it comes to charting are,
- How to combine two chart types in one chart, like a line chart combined with bar chart?
- How to add a secondary axis to the chart so that one or more data series are plotted on the secondary axis?
Watch this video tutorial to learn how to do both in less than 15 seconds.
Watch it on youtube: Creating combination charts and adding secondary axis – video tutorial
Team To Do Lists – Project Tracking Tools using Excel [Part 2 of 6]
In today’s installment of project management using excel, we will learn about project tracking tool – to-do lists. Projects are nothing but a group of people getting together and achieving an objective – like building system or constructing a bridge. While it is important to have a overall project plan and vision, it is equally important to understand how various day to day project activities are going on. This is where to do lists can help you a lot. Read on…
Gantt Charts – Project Management Using Excel [Part 1 of 6]
This is a 6 part tutorial on project management using microsoft excel. These posts represent few of the things related to project management using excel that I have learned over the years. The first installment deals with Preparing & tracking a project plan using Gantt Charts in MS Excel.
The other parts I am planning are, Day to day operations – using to do lists, Preparing a project time line, Time sheets and Resource management, Tracking issues and risks, Project Status Reporting – Dashboard.
Read the first part of the article to learn how to make excel gantt charts / project plans.
Incell Dot Plots in Microsoft Excel
Dot plots are a very popular and effective charts. According to wikipedia “Dot plots are one of the simplest plots available, and are suitable for small to moderate sized data sets. They are useful for highlighting clusters and gaps, as well as outliers.”
Today we will learn about creating in-cell dot plots using excel. We will see how we can create a dot plot using 3 data series of some fictitious data.
Highlight Top 10 Values using Excel Conditional Formatting
In excel conditional formatting basics article, we have learned the basics of excel conditional formatting. In this article we will learn how to highlight top 5 or 10 values in a list using excel as shown aside. We will use LARGE excel formula and conditional formatting to do this.
Excel Conditional Formatting Basics
Do you know What is excel conditional formatting? Learn the basics, few examples and see how you can use it in day to day work in this installment of spreadcheats.
Us vs. Them – Compare Sales Performance using Charts & Form Controls
Today we will learn a little trick to compare 1 value with a set of values, For eg. our sales vs. competitor sales. We will learn how to create a chart like this.