Welcome to SpreadsheetWEB Blog
What’s New in SpreadsheetWeb 6.9
Microsoft has recently announced that they will be adding dynamic array formulas into Excel. This functionality is already available for a number of users on the Office 365 platform, but widespread release should be coming soon. Dynamic array formulas are...
Pie Chart in Excel
A pie chart is a graphic representation of data on a circle divided into a number of slices. Each slice is drawn proportional in size to represent the contribution of each item to the whole. Note that pie charts can only show single series of data, and are...
See How an Inspection Tool Can Do Much More as a Web Application
Be it for machinery check-up, workplace safety, or home surveying, inspection applications have one thing in common: capturing as much information as possible about the item or stage being evaluated. Let’s take a home inspection tool as an example. A...
Scatter Chart in Excel
A scatter chart is a graphic representation of data by placing a collection of points on Cartesian Coordinates. The position of each point is determined by the value of two variables, one for the x-axis and the other for the y-axis.Scatter charts are...
What’s New in SpreadsheetWeb 6.8
In this update, we’ve introduced many new thrilling features that will allow you to do more with your designer applications that are even more flexible than ever. One of the biggest changes in this version is that you can now include the designer charts...
Creating an Interactive Pricing Application using Excel’s New Dynamic Array Functions
Dropdown style inputs are very useful in the sense that their use can expedite the data entry process in most applications. Imagine you want to use this feature to create sequential questions that affect each other, like disabling some options based on the...
Security Audit Forms Work More Efficiently as Web Applications
To ensure their vendors have necessary measures in place, businesses often request security audit forms that capture details about vendor practices. These forms typically consist of questions regarding physical and digital security systems, common...
Pivot Table Alternative Using Formulas
Excel’s Pivot Tables are very powerful in the sense that you can perform most data organization and analysis tasks on the fly. Although Pivot Tables have several advantages over using formulas for the same effect, working with Pivot Tables can be tricky in...
Area Chart in Excel
An area chart is a graphic representation of data by highlighting the areas between the axes and the plot lines. Being a variation of the line chart, the area chart places more emphasis on the “gap” between the data and the axis, and is commonly used to...