Software engineer Chandoo shares some Excel conditional formatting tricks that make for good-looking and useful spreadsheets, like a Gantt chart. Conditional formatting makes a cell look a certain way ...

Save time on status decks with a reusable Excel timeline chart. Data lives in a table, so new milestones update the timeline automatically.

Excel offers many different tools for formatting your charts, but the key to success is choosing which ones to use. In this ...

Have you ever come across a Wall Street Journal chart and thought, “Wow, I wish I could create something that polished”? Whether you’re preparing for a big presentation, crafting a report, or simply ...

Conditional formatting highlights key information in a spreadsheet so it’s easy to see at a glance. This beginner’s guide gets you started. Spreadsheets usually hold a wealth of information, but it ...

Excel’s chart features can turn your spreadsheet data into compelling visual communications—if you know what to do. This guide will walk you through the basics of setting up trends, percentages, ...

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

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

A date-and-cost line chart tracks a commodity's changing price over time. Economists use such diagrams to display broad market trends and predict future prices. Businesses that restock continually use ...