When charting values, Excel 2007 isn’t always careful how it formats the values that appear on the y-axis (or the x-axis when using some chart types, such as the 3-D Column chart or the XY Scatter chart [more…]
The typical chart (or graph) in Excel 2007 comprises several distinct parts, including the chart area, data series, axes, legend, plot area, gridlines, data markers, and more. The following list summarizes [more…]
After you create a chart in Excel 2007, you may need to change the range of the source data that is the basis for the chart. The Select Data Source dialog box lets you choose a different source range for [more…]

After you create a pivot table in Excel 2007, you can create a pivot chart to display its summary values graphically. You also can format a pivot chart to improve its appearance. You can use any of the [more…]
When you display your data visually in Excel 2007, choosing the right type of chart is just as important as deciding to use a chart at all. Different charts display the data in very different ways. Using [more…]

Printing a chart in Excel 2007 is a breeze, but the method you choose for printing the chart depends on whether you want to print an embedded chart (with or without the surrounding worksheet data) or a [more…]
The dashboards and reports of Excel 2007 offer a wide range of Excel tools, and it’s always nice to see the approach others take to design their reporting mechanisms. The following Web sites [more…]