So, you want to know how to create a scatter plot in Excel. Chances are, you probably already know what the term means, but given Microsoft Excel’s arsenal of options packed into each tab, getting ...

Q. As a conclusion to each project, we evaluate our project time and cost estimates for accuracy. Obviously, underestimating is a problem, but over-estimating is also a problem that leads to ...

If you understand the definition of a mathematical function, a good way to judge it is that any line drawn parallel to the y-axis intersects with the values in the function’s curve only once. The same ...

The legend on an Excel scatter plot is simply a list of the names for each of the series on the chart. The legend is color coordinated, so you can quickly determine which data points belong to which ...

Making a square bubble chart in Microsoft Office Excel is possible if you slightly modify the chart. A bubble chart is a type of scatter chart in which your data points are shown as bubbles. These ...

The new Analysis ToolPak is designed for complex statistical and engineering work. However, it’s not turned on by default so you need to activate it yourself when you want to use it. Go to the main ...

Microsoft Excel has more dataviz capabilities than you may realize. Find out how to make your data stand out with charts, PivotTables, sparklines, slicers and more. Everyone knows Microsoft Excel as a ...

Excel 2016’s many new features include six new chart types. We’ll go over Histogram, Pareto, and Waterfall and talk about how they could be used with your data. We covered Treemap, Sunburst, and Box & ...

Have you ever faced the daunting task of identifying and prioritizing risks in a project, only to feel overwhelmed by the sheer complexity of it all? Whether you’re managing a multi-million-dollar ...