Quantcast
Home Array Removing Array Formulas Around Your Excel Charts and Dashboards

Removing Array Formulas Around Your Excel Charts and Dashboards

Yesterday I posted a quick tutorial on protecting your Excel Dashboard Charts by using Array Formulas.

You can check out that posting here:

Protecting Your Excel Charts and Dashboards with Array Formulas

Well I guess I forgot to tell you how to remove the Array Formulas from around your Excel Charts.  Sorry Sad smile

Here is a quick video showing you the trick.  (Hint, the trick is that you have to highlight and delete the entire array area in the spreadsheet.  The video shows you how to make sure you know what is the exact range).

Check it out:





 

Thanks for the feedback in my YouTube Comments!

Steve=True

C:\Users\SteveT\Documents\Niche Websites\ExecutiveDashboard\Blog Posts





NO COMMENTS

LEAVE A REPLY

Please enter your comment!
Please enter your name here

Want to Receive the Next Post?
Join My Newsletter
Subscribe
Give it a try, you can unsubscribe anytime.
Privacy Policy
Close
Subscribe Now!   (Privacy Policy)
SUBSCRIBE

Stay Connected!

Get the latest post emailed straight to your inbox!
SUBSCRIBE
close-link