Tuesday, December 11, 2018

Create a Bubble Chart

If you've create x y scatter charts, you'll probably like bubble charts. In addition to the horizontal and vertical series of data, you can add a third series of data which will show the difference between variable by varying the size (like the size of a circle or bubble). Check out the video to learn how to create a bubble chart and also using images or picture in the bubble instead of the colors.


Monday, December 10, 2018

Convert Text to Numbers or Numbers to Text

This video covers how to convert or change text to numbers using several methods. Also how to convert or change numbers to text using some different methods.


Wednesday, December 5, 2018

Create a Drop Down List with a Combo Box or List Box

This video shows you how to create a dropdown list with an Active X Combo Box Control. Other examples include how to create two type of lists with an Active X List Box.


Tuesday, December 4, 2018

Create a Tornado (Butterfly) Chart

If you're into data visualization or info grahic charts, you might have seen these type of bar charts to flare out to the left and right sides. Sometimes it's called a butterfly chart or tornado chart chart. It's not too hard to create these charts so check out the video to learn how.


Monday, December 3, 2018

Create a Pareto Chart

Have you ever heard of the 80 20 rule? It's based on the idea of the Pareto principle which was named after an Italian economist. Basically it proposed that a small percentage of inputs where responsible for a large percentage of outputs. Like a small percentage of a population held the wealth or wealth creating aspects of the larger population. Often you may see charts to try to visualize this and sometimes they are called Pareto charts. To see how we can create a simple Pareto chart, click the video to learn.