# How to create large text containing numbers

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
=RANDBETWEEN(1111111111111110,9999999999999990)
• 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!

# Quality Management 6: Scatter Diagram

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.

# Quality Management 5: Pareto Chart

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.

# Quality Management 4: Histogram (using Excel 2016)

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.

# Quality Management 4: Histograms (any version of Excel)

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.