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

One of the advantages of using Excel as your spreadsheet application is that you can display a simple piece of information just as effectively as a complicated collection of data. For instance, you ...

If you use Microsoft Excel regularly for studying or work that requires a spreadsheet to be filled with data-driven information, then you know it can be quite difficult and time-consuming to decipher ...

How to create a YOY comparison chart using a PivotChart in Excel Your email has been sent Need to know your organization's YOY results? Susan Harkins will show you how to make a PivotChart in ...

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

Slicers provide an intuitive, user-friendly interface for filtering data in a spreadsheet. Here’s how to create slicers, format them, and use them to filter data in Excel. Spreadsheets’ greatest ...

How to Extract a Substring in Excel Using FIND() and MID() Functions Your email has been sent Learn how to use MID() and FIND() and then combine them to parse substrings from inconsistent data.

Brian Beers is a digital editor, writer, Emmy-nominated producer, and content expert with 15+ years of experience writing about corporate finance & accounting, fundamental analysis, and investing.

Daniel Jassy, CFA, is an Investopedia Academy instructor and the founder of SPYderCRusher Research. He contributes to Excel and Algorithmic Trading. Return on investment (ROI) measures the amount of ...

When you create a graph that includes dates, Excel 2013 automatically spaces the data in chronological order. This behavior potentially creates irregular spacing with unpredictable formatting. If the ...