Make data labels dynamic Excel Tips and Tricks
>> YOUR LINK HERE: ___ http://youtube.com/watch?v=tbDuZe8u7mY
Learn how to make data labels dynamic in Excel. • Here are the steps outlined in my video. • Add Chart • 1) Ctrl + A • 2) Alt + F1 • 3) Resize and reposition chart • 4) Chart Design ~ Change Chart Type • 5) Combo • 6) Line • 7) OK • 8) Remove redundant axis and title • 9) Change chart style • I like the one with shadow... but choose the one you like. • Dynamic Data Labels • 1) Select line chart • 2) Add Data Labels , Center and Above • 3) Right-click on line chart ~ Outline to No Outline • 4) Right-click on the data label ~ Format Data Labels • 5) Format Code set to • [green]▲#0%;[red]▼#0% • 6) Add • Alt keys for up and down arrow head characters. • ▲ Alt+30 • ▼ Alt+31 • #tips #excel #shorts #fyp
#############################
New on site