Three Excel features—a combo box, an INDEX function, and the GETPIVOTDATA function—work together to create a custom chart for any representative. To assist you in creating the column chart, we have ...

Creating a Balanced Scorecard for your organization is a smart, strategic move. Its takes work and thought and planning that can make you feel like you climbed a mountain once it’s complete. But you ...

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.

In Microsoft Excel 2010, a chart sits over the worksheet and provides a visual expression of the underlying data. You can use a chart in conjunction with elements on the worksheet to get a better ...

Excel won't display hidden data in a chart unless you flip the switch. Learn which option controls this behavior.