Scatter Chart (גרף X-Y)

The issue at hand: What is a Scatter Chart? When and how should be used? Scatter chart is mostly used to analyze data points (coordinates) and the relation between them. The pattern of the points in the chart may provide an idea of the relation between the pairs of points (coordinates); for example, creating a […]

Using the PurgeChar Function

The Issue at Hand: Excel data mixes text and numbers. Excel columns are defined as “Text”. How can one work around the data in Excel in a way that allows to create a numeric expression? Below is an example of “text” Excel data (data into the cells). Annual Salary $25,000 $100,000 $125,000 There may ways […]