Learn Excel 2010 -“Dynamic Chart Labels”: #1426




About this tutorial:

Video duration: 3:2
Today we will learn how to replace Numeric Chart Labels with a Formula using the method Bill gives in Episode #1426. Also learn to vary Colors by Point AND “Making Excel Columns Wider” using Gap Width. Learn Excel 2007 through Excel 2010 from MrExcel

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

5 thoughts on “Learn Excel 2010 -“Dynamic Chart Labels”: #1426

    Vinicius J

    (October 9, 2018 - 10:58 am)

    Hi Bill. First, thanks for all your excel videos!
    I have an issue and hope you can help me… I have a chart which is linked to a dynamic range of cells (by Name Manager). This chart works great but I'd like to add a second label (as you did above), however, this label has to be dynamic as well.
    For instance, this is what I have for my single axis label:

    ='Config Analysis'!$M$6:INDEX('Config Analysis'!$M$6:$AZ$6,'Config Analysis'!$L$1)

    For adding a second label I would need something like this:

    ='Config Analysis'!$M$6:INDEX('Config Analysis'!$M$6:$AZ$7,'Config Analysis'!$L$1)

    As you can see I have added a second row of label (AZ7). The issue is this formula does not work with two rows.

    Could you kindly help me?

    Thx in advance!!! Vinny

    wong William

    (October 9, 2018 - 10:58 am)

    what is the use of the option "vary colors by point"

    QuantumDK

    (October 9, 2018 - 10:58 am)

    What if you want to label like 50 points? 

    marcelaaugusta

    (October 9, 2018 - 10:58 am)

    Thank you from Brazil!

    ExcelIsFun

    (October 9, 2018 - 10:58 am)

    That is cool!!

Leave a Reply

Your email address will not be published. Required fields are marked *