Welcome to SpreadsheetWEB Blog
Surface Chart in Excel
A surface chart plots data on a three-dimensional surface, in a similar way that topographic maps visualize elevation. The colors and patterns represent values within the same range. This chart type is especially useful for finding the optimum results when...
How to Add Secondary Axis in Excel and Create a Combination Chart
A combination chart (also known as a combo chart) is a graphic representation of multiple data sets demonstrated with the use of different types of charts. This combination of charts is especially useful for visualizing different data sets side-by-side....
Radar Chart in Excel
A radar chart is a graphic representation using lines placed on axes that diverge from the center of the chart. A radar chart is very useful for visualizing performance analysis or survey data, that involves comparing multiple properties side by side. The...
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...