I was creating a video on data analytics today. I needed to show a graphic of lots of data scrolling in the background for the video title. This is how I did it.
- Create many rows of data by using this formula in Excel
- Copied the resulting data and pasted in Word as Text
- Search for ^p which means paragraph mark and replace with nothing
- This merged all the data into one big block of text
- Paste it into a textbox in PowerPoint and use it for animation to create the title for the video
The result looks like this. Moral of the story? Use the right tool in the right place!
When you have two columns of numeric data, Scatter chart helps you understand how they affect each other (jargon: correlation). Creating a scatter plot is easy. But interpretation can be misleading or even absurd. Let us explore how to create effective Scatter plots.
Read Histogram and Pareto articles first. Excel Data Analysis tool can create a Pareto chart while creating a histogram. Small tweak but very useful.
This chart is used to analyze important factors and prioritize action items. It is a combination of bar and line chart. Bar chart shows the data in descending order of importance and line chart shows cumulative percentage. It is popularly known as the 80:20 rule. We will see three ways of creating this chart using Excel.
Well, the histogram articles don’t seem to be ending. I promise, this is the last one. With Excel 2016, a new chart type called Histogram was introduced. Now we don’t need either Data Analysis ToolPak or Pivot Table to create a histogram. Have a look.
This is continuation of the previous article. In this article, we will see another way of creating Histograms using Pivot Tables.
Histogram is used to visualize the frequency with which data occurs. This is a good way of understanding data more than just sum and average. It is a good idea to look at each data set you get as a histogram. Here is how you do it in Excel.