Excel 2016's many new features include six new chart types. Here we cover Histogram, Pareto, and Waterfall, which cover statistical, trend, and other relationships.

To create dynamic dropdown lists, you typically need to use named ranges and the INDIRECT function in Excel. The function references a range of cells that change based on what you selected in the ...

In Microsoft Excel, to draw attention to a specific marker in a line chart, drop in a thin line, think of it as a marker.

Learn how to demonstrate your marketing data using sexy combination charts in Excel, with tutorials for PC (2013 and Mac (2011).

How to Change the Color Coding on a Microsoft Excel Graph Legend. Color can make it easier for people to identify important information, such as legends on an Excel graph.

How to Change the Intervals on an X-Axis in Excel. The X-axis, which is the horizontal axis, on most Excel charts does not use numeric intervals like the vertical Y-axis does.

Users will appreciate a chart that updates right before their eyes. In Microsoft Excel 2007 and Excel 2010, it's as easy as creating a table. In earlier versions, you'll need the formula method.