Are You Trendy ?
Often you may have a set of data and need to know what an intermediate or future value of that data may be.
This week we will investigate 3 methods of tackling this problem using Excel.
In this post we’ll look at manual forecasting.
Highlighting Data Points in Scatter and Line Charts
Introducing a method of allowing data points to be interactively highlighted in Excel Scatter / X-Y Charts and Line Charts.
You will see a lot of these style charts in various places where you want to highlight various aspects of the chart to your audience. It is a great technique for complex scientific and engineering charts where you may have hundreds or thousands of points.
A Technique for Analysing Large Tables of Data
Once you start using Excel to develop systems, budget, forecast and large tables of data you may come across the dilemma of “How do I know this is right” or “How do I truth check this”.
This post will add a tool to your arsenal to help you out.
Excel School Closing in a Few Hours – Join Now!
As some of you know, I run an online Excel Training Program called as Excel School. I have opened registrations for 3rd batch of this program on September 14th. Thank you very much for supporting this program wildly. In a few hours, I will be closing the registrations for Excel School.
Click here to sign up for Excel School
Read the rest of the post to learn more about Excel School and also download time across world chart template.
Official FIFA World-cup Soccer Balls since 1930 in an Excel Chart [Excel Fun]
The FIFA World-cup 2010 edition is around the corner. Like millions of people around the world, I too am an ardent fan of football. (although, I have played only one game of soccer in which I waited near opponents goal post as I was too lazy to run around. And when my team mates kicked […]
Evolution of Privacy Policies on Facebook – a Panel Chart in Excel
Out of curiosity I took the data from Matt McKeon’s Privacy on Facebook chart and try to re-do the chart in Excel. I made a panel chart depicting how Facebook’s privacy policies have changed since 2005. You can see a bigger version of chart as well as get the download excel from the post. Read on…
Change Data Labels in Charts to Whatever you want [Quick Tip]
We all know that Chart Data Labels help us highlight important data points. When you “add data labels” to a chart series, excel can show either “category” , “series” or “data point values” as data labels.
But what if you want to have a data label that is altogether different, like this:
Of course you can point data labels to any cell. In this quick tip, we will learn how to do this, read on…