Wednesday, May 15, 2019
Use the SEARCH Function
If you're looking for some text string or other values within a cell you can use the Find feature in Excel. But what if you wanted to do this programatically and have it execute for every row without manual interventions. It can be done with a built in function called SEARCH...see the video to learn how to use the SEARCH function in Excel.
Tuesday, May 14, 2019
Create a Bubble Chart with Multiple Series of Data
Ask kids if they like bubbles and most likely you'll get a resounding "YES!" Heck even some adults like bubbles. I think it has something to do with the shiny curves and the airiness of these spherical entities. So when you have the chance to add more bubbles to your Excel bubble chart why not? It actually not that hard to add more more series of data to your chart. But be careful of adding too many series (bubbles), because just like a washing machine overloaded with too much detergent, a bubble chart can be overloaded with too many bubble.
Monday, May 13, 2019
Create a Motion Bubble Chart
If you're familiar with a TED talk given by the late Hans Rosling, you're problem familiar the the cool motion chart he showed with about world development. It had data, it had animation and it had drama! You can replicate the data and animation part (the drama you'll need to provide) in the example of how to create a motion bubble chart from this video.
Subscribe to:
Posts (Atom)