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!
Related: Data visualisation tools
Data Visualization Review: Gephi, Free Graph Exploration SoftwareI do not often get to play with networks, yet I find them fascinating and full of knowledge gathering potential. The data visualization works of Moritz Stefaner, Jer Thorp, and Mark Lombardi captivate me. I am intrigued by relationships, how we perceive them, and how we can understand them. Gephi, the "Open Graph Viz Platform", is not just for the hobbiest node nerd. So what is Gephi capable off? Gephi interface displaying airline traffic data. Pros — Options! Cons — Interface is a bit cluttered. Main interface displaying the Diseasome data. Review Overall, Gephi is a useful and interesting tool. There are some plugins available for Gephi that extend the functionality. The only thing keeping Gephi from being a professional grade tool is its bugginess and lack of documentation. Graph of Minard's data using Gephi and the GeoLayout plugin. For the Purists Gephi is a purist's delight. Two nerdy charts of network statistics that Gephi will output.
Pearson Software Consulting, LLC, Comprehensive Excel InformationThis web site is brought to you as a public service by Chip Pearson and Pearson Software Consulting, LLC. We provide complete consulting and custom application design and development for Excel, Office, Visual Basic, and the NET Framework in VB.NET and C#. For more information about how to turn Excel into a powerful application platform, contact Chip Pearson at (816) 214-6957. This web site contains about 500 individual topic pages that together cover all aspects of Excel, from simple formulas through Automation and COM Add Ins and into the NET Framework. The content of the site provides you with the tools you need to create workbooks and VBA projects. I have not yet upgraded all the modules to 64-bit Office, so some of the code may not work in 64-bit Office, especially code that uses the Windows API functions with the Declare syntax.
Contextures Excel BlogSWF Charts > IntroductionXML/SWF Charts is a simple, yet powerful tool to create attractive charts and graphs from XML data. Create an XML source to describe a chart, then pass it to this tool's flash file to generate the chart. The XML source can be prepared manually, or generated dynamically using any scripting language (PHP, ASP, CFML, Perl, etc.) XML/SWF Charts makes the best of both the XML and SWF worlds. Features: Quick generation of charts and graphs from static or dynamic data (any scripting language) Full updates and data streaming without reloading the web page. Testimonials I just wanted to pass along how well your script worked for our stock performance page. Good work! This is amazing software. Just want to thank you for this wonderful upgrade. I purchased your product a couple days ago and first had time to sit down and work with it this morning. Wow, you are the best! Thanks for your great script. I am very excited to have found your product on "hotcripts". You are freaking amazing. THIS ROCKS!
Excel ZoomExcel VBA Macros for Absolute Beginners - 15 Examples File download - ANALYSISTABS - Innovating Awesome Tools for Data Analysis!Excel VBA Macros for Absolute Beginners – These 15 macros provides the easiest way to understand and learn the basics of VBA to deal with Excel Objects. Learning Basic Excel VBA By Examples is the easiest way to understand the basics of VBA to deal with Excel Objects, in this tutorial we will not covering any programming concepts, we will see how to access the different Excel Object using VBA. Excel VBA Macros for Absolute Beginners – Download file with 15 Examples: Example 1: How To Access The Excel Range And Show The Value Using Message Box While automating most of the Excel Tasks, we need to read the data from Excel spread sheet range and perform some calculations. Example 2: How To Enter Data into a Cell After performing some calculations using VBA, we generally write the results into worksheet ranges. Example 3: How To Change The Background Color Of A Particular Range The following example will help you in formatting a cell or range by changing the background color of a range.
Student Performance DashboardDashboard Description: Top section gives comparative analysis of Class teachers Maths class (based on latest math assessment score) with the her other classes, overall school performance and district. Looking at the data her current class performance is below Average compared to her other classes. Class Summary: All Students are categorised in different colors based on their latest math assessment score. Similar to performance, I have categories behavioural data in different shades of blue. Top Right section gives comparative analysis of detailed student performance with other classes, school and district level students. Right bottom gives overall details of students which requires special disciplinary and performance attention.
Excel Experts E-Letter ArchivesThe Excel Experts E-Letter (or EEE) is a newsletter produced by David Hager. EEE is filled with useful tips and tricks for Excel. Most of the material in geared towards the more advanced user. Note: The EEE newsletter is no longer distributed via email. Any future issues will appear here. I'm pleased that David has agreed to make the past issues available from The Spreadsheet Page. EEE Back Issues Following are links to past issues of EEE. Issue No. 20 (July 8, 2001): Formula to count unique items in filtered column.Hive Plots - Linear Layout for Network Visualization - Visually Interpreting Network Structure and Content Made Possible