×

Autochart

Remove Chart Data Labels With Specific Value

Remove Chart Data Labels With Specific Value

There may be times when you would like to de-clutter your data labels so that smaller or zero values are...

Add Vertical Lines To Excel Charts [Best Way!]

Add Vertical Lines To Excel Charts [Best Way!]

There are a few creative ways to add a vertical line to your chart bouncing around the internet. If you...

VBA Code To Hide All Shapes Within A Chart Object

VBA Code To Hide All Shapes Within A Chart Object

What This VBA Code Does If you are trying to hide all shapes in a worksheet, yet some of those...

How To Create Excel Progress Bar Charts (Professional-Looking!)

How To Create Excel Progress Bar Charts (Professional-Looking!)

Creating A Progress Bar In Excel Progress Bars are simple graphics that can be quite visually powerful by instantly providing...

VBA Code To Loop Through Only Selected Excel Charts

VBA Code To Loop Through Only Selected Excel Charts

What This VBA Code Does The following VBA macro will show you how to loop through only chart objects that...

VBA Code To Remove Line Series Markers From All Charts On Excel Spreadsheet

VBA Code To Remove Line Series Markers From All Charts On Excel Spreadsheet

What This VBA Code Does It happened again today...I received 10 Excel line charts that needed to be "properly" formatted...

VBA Code To Change All Shape & Chart Placement Properties

VBA Code To Change All Shape & Chart Placement Properties

What This VBA Macro Does I deal with shapes and charts on a daily basis and one of my (many)...

Create A Bar Chart With Separate Positive And Negative Colors

Create A Bar Chart With Separate Positive And Negative Colors

Our goal as analysts is to tell a story with our data and it is a well-known fact that data...

Loop Through All Chart Sheets In An Excel Workbook

Loop Through All Chart Sheets In An Excel Workbook

What This VBA Code Does There are two types of Sheets within an Excel Workbook. Worksheets Chart Sheets The below...

The VBA Coding Guide For Excel Charts & Graphs

The VBA Coding Guide For Excel Charts & Graphs

Charts, Charts, & More Charts! Graphical visualizations are arguably the pinnacle of how an analyst shares his/her results and possessing...

Automatically Extending Excel Chart Series' Ranges For Next Year

Automatically Extending Excel Chart Series' Ranges For Next Year

It's That Time Of Year Again! For most of us, the months of November and December are spent preparing our...

Make All Charts Plot Non-Visible Cells in Your Excel Workbook

Make All Charts Plot Non-Visible Cells in Your Excel Workbook

What This Does When you create a chart in Microsoft Excel, the chart's default setting is to not graph any...

Convert Externally Linked Graphs Into Pictures In Your PowerPoint Presentation

Convert Externally Linked Graphs Into Pictures In Your PowerPoint Presentation

What This VBA Code Does This PowerPoint VBA macro code will cycle through all the externally linked charts in your...

Loop Through & Make Changes To All Excel Charts In The ActiveWorkbook

Loop Through & Make Changes To All Excel Charts In The ActiveWorkbook

What This VBA Code Does Keeping all your charts perfectly formatted can be extremely tedious work!  It's much easier to...

Scroll To Chart Based on Form Control Combo Box Selection

Scroll To Chart Based on Form Control Combo Box Selection

In my previous post VBA For Excel's Form Control Combo Boxes, I showed you all the different actions you can...

Hiding A To-Date Column When Reporting Month or Quarter End Results

Hiding A To-Date Column When Reporting Month or Quarter End Results

The "To-Date" Column I was first introduced to this concept a few years ago when I first started working in...