There may be times when you would like to de-clutter your data labels so that smaller or zero values are...
There are a few creative ways to add a vertical line to your chart bouncing around the internet. If you...
What This VBA Code Does If you are trying to hide all shapes in a worksheet, yet some of those...
Creating A Progress Bar In Excel Progress Bars are simple graphics that can be quite visually powerful by instantly providing...
What This VBA Code Does The following VBA macro will show you how to loop through only chart objects that...
What This VBA Code Does It happened again today...I received 10 Excel line charts that needed to be "properly" formatted...
What This VBA Macro Does I deal with shapes and charts on a daily basis and one of my (many)...
Our goal as analysts is to tell a story with our data and it is a well-known fact that data...
What This VBA Code Does There are two types of Sheets within an Excel Workbook. Worksheets Chart Sheets The below...
Charts, Charts, & More Charts! Graphical visualizations are arguably the pinnacle of how an analyst shares his/her results and possessing...
It's That Time Of Year Again! For most of us, the months of November and December are spent preparing our...
What This Does When you create a chart in Microsoft Excel, the chart's default setting is to not graph any...
What This VBA Code Does This PowerPoint VBA macro code will cycle through all the externally linked charts in your...
What This VBA Code Does Keeping all your charts perfectly formatted can be extremely tedious work! It's much easier to...
In my previous post VBA For Excel's Form Control Combo Boxes, I showed you all the different actions you can...
The "To-Date" Column I was first introduced to this concept a few years ago when I first started working in...