Ad Clicks :Ad Views : Ad Clicks :Ad Views : Ad Clicks :Ad Views : Ad Clicks :Ad Views :
    Excel formulas and tutorials

    Excel formulas and useful tools

    Home / Excel / Charts / Include a dynamic variable text box in a chart or graph

    Include a dynamic variable text box in a chart or graph

    /
    /
    /
    735 Views

    Trying to make charts more expressive is anyone’s objective so that he/she doesn’t have to modify the chart every time a piece of data changes in the source of the graph. Do this by adding variable text boxes inside the chart template.

    Include dynamic text box in chart

    As you can see in the picture, there is an average calculated and displayed in the middle of the chart.

    How to insert a dynamic calculated variable text box inside a chart

    This is very simple. We just have to select Text Box from Insert tab and place it where we need it (click + drag and release). Don’t edit it, the content must be empty. We need it to be dynamic (to display the value from inside a calculated excel cell -let’s say the average calculation at the end of the December cell, that keeps updating as the values for each month are filled).

    Select the text box and the select the formula bar from the top of the excel spreadsheet. Here you must type “=N5” and hit Enter. That’s all.

    Note that the word “Average” inside the chart is a stand alone text box that is not dynamic.

     
    • Facebook
    • Twitter
    • Google+
    • Linkedin
    • Pinterest

    Leave a Comment

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

    This site uses Akismet to reduce spam. Learn how your comment data is processed.

    This div height required for enabling the sticky sidebar