Trend lines are a type of regression analysis, which is a way to study the relationships between variables. In the context of small business, trend lines are often used to show sales trends and can be ...

When you dive into Excel, you quickly realize the power it holds for data analysis and prediction. Two of the most potent tools at your disposal are the TREND and FORECAST functions. These functions ...

Data is rarely so uniform and predictable that plotting data points creates a perfectly linear arrangement. Scatter charts might have wildly varying plots that create a seemingly random correlation ...

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 ...

An curved arrow pointing right. Sparklines are word-sized charts that live in individual cells. This great feature was added to Excel in 2010 but still remains massively underutilized. Produced by ...

The ease with which you can create a line graph in Excel on your PC or Mac will do much to dispel the misconception that the program is arcane and unapproachable. With just three clicks of a mouse (or ...

How to add a single vertical bar to a Microsoft Excel line chart Your email has been sent There are lots of ways to highlight a specific element in a Microsoft Excel chart. You might add data labels ...

So far in this series, we have looked at querying systems using WMI to pull the drive space and then spent some time looking at sending that data to a SQL server database where it can be saved for ...

We are very glad to let you know that we have created a new Excel Peter Lynch Chart template that illustrates the valuation bands based on the historical median P/E, P/S and P/B ratios. The P/E bands ...

How to make the default area chart in Microsoft Excel more attractive Your email has been sent Microsoft Excel produces great charts, but sometimes they’re not visually pleasing. Learn how to change a ...