Constable Henry: Just a moment, sir. I know everyone in this neighborhood, but I’ve never seen your face before. Can you account for yourself? Freddy: Yes, I am Dr. by The FrankensTeam This guest post is from the E90E50 FrankensTeam, i.e., Roberto Mensa, Kris Szabó, and Gábor Madács. While I was reading Jon’s work using VBA Approaches to Plotting Gaps in Excel Charts I started to think, because I felt there had to be another solution which was waiting to be discovered… Jon provided two different VBA routines as a solution for the problem: one changes the chart series formatting, the other changes the underlying data. Some time ago I realized that it is possible to use union of ranges in chart series. Now, a few months later, thinking about the gap problem… Eureka! The union of separate ranges could be a solution, especially if we can build it up using the UDF within a named formula! Let us explain how it could work. The series formula of the chart looks like: =SERIES("ref to rng",,line_chart!
bayapartmentbroker | Just another real estate investing blogMoneychimp: learn Stock Investing, Index Funds, Valuation Models, and more.The 99 Best Business Books - The Personal MBA - The Personal MBA: Master the Art of Business“You wasted $150,000 on an education you coulda got for a buck fifty in late charges at the public library.” Will Hunting (played by Matt Damon), Good Will Hunting MBA programs don’t have a monopoly on advanced business knowledge: you can teach yourself everything you need to know to succeed in life and at work. The Personal MBA features the very best business books available, based on over ten years and thousands of hours of research. This page lists all Personal MBA recommended books and resources for easy printing, bookmarking, and reference. Here are the 99 business books The Personal MBA officially recommends… click on the title of each book to read a detailed description of each book and why it’s important, or the buttons to the right for additional reviews. Books purchased through this website support The Personal MBA’s ongoing research. Read This First For Best Results... Buy the Book: WANT TO BE NOTIFIED WHEN UPDATES ARE PUBLISHED? Business Creation Value-Creation & Testing Marketing