Custom Excel Chart Label Positions | GHOST Trick 

Hi Mynda, I love your videos and I always learn clever tricks from you. Thanks!

Loving these recent charting tips, very creative and helpful thank you!

Awesome trick. How do I add data labels for targets as well on top of bar without overlapping the data labels for the Actuals (ghost)

Love it. I toyed around and added a second ghost column "Labels_2" for the "Target" data. Then changed the formula for "Labels" to =IF([@Actual]>=[@Target],MAX(Table1[@[Actual]:[Target]])+1000,MAX(Table1[@[Actual]:[Target]])) and the formula for "Labels_2" to =IF([@Actual]

Holy cow there's a a ton of useful technique to be had here. Very relatable to a lot of charting I do and builds a much better foundation. Thanks so much for sharing!

This technique saved me a ridiculous amount of time on a project. Thank you!

Hi Mynda.. a brilliant solution! Simple and effective.. love it! Thanks for sharing your great tips and techniques. I always enjoy pulling things like this out of my toolbox when someone asks.. how can I do this or this? Thumbs up for MyOnlineTrainingHub!!

Real-Target it's a classic question demanded by companies. Thank you for your tips Mynda!

Beautiful charting trick and tips. Thank you Minda

Hi Mynda!Love These Really Helpful Tips And Tricks Thank You So Much :):):)

Gah this is so much easier than moving the labels 1 by 1 and then trying to align them! Thanks!

Perfect Mynda, thanks for sharing 👍👍😍

Nice Trick! How about removing the Y-Axis to make the chart more clean. 😉

Yes. A big thumbs up from me. Very useful. A definite for me! Thanks a lot. Short and to the point. Great.

Great example! Can this be done in a pivot table? How to add formula of the maximum?

very useful thanks a lot

Im going to make use of this like right now! Thank you!

This didn’t really change the label position. I want to be able to set the label position to the end of a line chart but have the number come from a cell. Any advice?

So useful. Thank you! Your puns went over my head though. I'm on the wrong side of the Atlantic, don't blame me.

BTW ghost series sounds so cool.

Thanks, Mynda, nice tip. What do you suggest for stacked columns/bars? I often use them to display segments, but usually want to display only the total value in a label outside the end. It always vexes me. My trick is to add a ghost segment with a small fractional value as the last segment, then label only it with the total value. Is there a better way?

How do you do this will multiple columns of data? I have 5 columns of data.

I want to add text inside column not data label

how to overlay two bar in same position. like you did :Actul / target both bars in the same position.

I've added labels, but am not getting any label position options??

I need my labels to only appear when my mouse hover over the data point

The Data Label values are horizontal, is there any option for showing them Vertical on the Bars like "10,000" is not written from left to right but from bottom to top? Please Help