Look Who it Was Random video

Excel - Microsoft Excel - Add Chart Labels Between Points - Episode 956

3,580 views · Published 23 February 2009 · 3:13 · Indexed 6 November 2026

Channel: MrExcel.com · 2009 · Education

Watch on YouTube

Microsoft Excel Tutorial - Microsoft Excel - Add Chart Labels Between Points.

Welcome back to the MrExcel netcast! In today's video, we're going to tackle a question sent in by Tamir. Tamir has a chart that shows data for each point, but he wants to label the chart between the columns. This can be a tricky task, but I have a solution that involves creating an invisible series. Let's dive in and see how we can add chart labels between points in Microsoft Excel.

First, we start with a massive amount of data that needs to be analyzed. We'll use a pivot table to help us solve this problem. However, Tamir's request for labels between columns requires a different approach. In real life, we could use Rob Bobby's XY chart labeler, which allows us to use any range for labels. But in this case, we'll use a trick that involves creating an invisible series.

To begin, we'll add an extra column for the Delta values. This will create a red column between each blue column in our chart. We can then adjust the width of these red columns to our liking. In Excel 2003, we can do this by going to the options tab in the format data series dialog box. Once we have our columns set up, we can add data labels to the red series. But we don't want the red bars to appear, so we'll make them invisible by changing the fill and border color to "no fill" and "no line", respectively.

Now, we have our labels appearing between the columns, but they may not be in the exact location we want. To adjust this, we can modify the data set by adding an invisible one series and an invisible two series. This will help us position the labels at the top of each column. It may seem like a lot of work, especially when there are add-ins available for this task. But if you don't want to use an add-in, this method can still get the job done.

I want to thank Tamir for sending in this question and I hope this solution helps you with your chart labeling needs. As always, thank you for watching and be sure to check out our other netcasts for more Excel tips and tricks. See you next time!

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/


Microsoft Excel Charting Tutorial: Can you add labels between points?

Tamir asks if you can add labels between columns in a chart. Episode 956 shows a tricky way to solve this.

Table of Contents:
(00:00) Introduction 
(00:14) Question from Tamir 
(00:24) Labeling a chart 
(01:06) Creating an invisible series 
(01:27) Adjusting data labels 
(02:31) Alternative method 
(02:48) Thanking Tamir 
(03:00) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial 

This video answers these common search terms:
Adding data labels and removing bars
Creating an invisible series to add labels between columns
Data analysis and visualization techniques in Excel
Formatting data series in Excel 2003 for wider columns
Modifying the data set for customized labels
MrExcel netcast tutorial series
Pivot table analysis for data visualization
Thanking Tamir for the question
Tips for positioning labels at the top of columns
Using an add-in versus manual method for chart labeling
Using Rob Bobby's XY chart labeler for labeling charts
YouTube video tutorial on creating chart labels between columns

Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1152247/

More from this channel