Welcome to SpreadsheetWEB Blog
What’s New in SpreadsheetWeb 6.10
In this version, we’ve introduced a new Queries module. Using this module, you can create your own database queries without any coding whatsoever. All you need to do is to select the application or data map you want to work with, pick the columns from that...
Stock Charts (Candlestick) in Excel
A stock chart, also known as a candlestick chart, is a visual representation of a multitude of data on a timeline. This visualization type is typically almost exclusively used for visualizing stock market prices. The data series appear like candles with a...
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...