This is very cool, Ken.
You can view the page at http://www.excelguru.ca/content.php?...P-for-Pictures
Ken Puls, FCPA, FCMA, MS MVP
Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training), with my book M is for Data Monkey, or our new Power Query Recipe cards!
Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter
If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.
This is very cool, Ken.
Really Cool --Good Job
Thanks guys.![]()
I use something similar for Dashboards, enabling the user to change Charts & even data views.
Wallha very good
I have tried this method and actually a similar method and I get an "Reference not valid" when it comes to changing the picture formula to =Day_01. Any suggestions on what I am doing wrong?
It's great...
Hi, I have the same problem as Victoria had. Are you sure, we select A4:E5 in this step and not A3:E4?
thanks
- Select cells A4:E5
- Go to Formulas -->Defined Name -->Create from selection
- Choose to created names from values in the Top Row (only)
Bookmarks