To adjust a color, choose Tools, Options, Color. In this dialog, choose the color you need to change. Then choose Modify.
In the Colors dialog, choose the Custom tab. As shown here, you'll see the color in a vertical band, with a black arrow that serves as a slider.
Click and drag that slider up or down to vary the intensity of the color, from white to black.
To vary the hue (to make it more red, or blue, or whatever) change the Red, Green, or Blue numbers, or click and drag the white cross around the face of the color display.
When you have the color you want, choose OK.
How to adjust colors in New Excel
In Excel 2007 it's not always possible to determine which color position needs to be adjusted.
If you select a cell you can learn this information. As in Classic Excel, choosing the Fill Color icon from the Home tab will show a color palette with the color position highlighted.
But certain chart objects offer no way to determine their color position.
Therefore, to adjust the color of a PNP dashboard, you'll often need to refer to the figures below.
The left figure labels seven color positions, which are explained in the table.
For example, the Light 2 color position is labeled zero, and the table shows that we use this color position for the backgrounds of tables in plug-and-play dashboards.
For variety, most PNP dashboards use two different styles of chart figures, which this table refers to. This dashboard image labels these styles.
Once you've determined which color position you want to change, choose Page Layout, Themes, Colors, and then right-click the highlighted custom color and choose Edit. (If a custom color isn't highlighted, choose the custom color and then return to right-click your highlighted choice.)
In the Edit Theme Colors dialog, choose the color you want to change. Then choose More Colors at the bottom of the Theme Colors palette. Doing so launches the same Colors dialog shown for Classic Excel above. Use the same approach to adjust New Excel's theme color.
To point a chart figure at data in a different supporting worksheet, just change the sheet name that the four formulas in each figure reference.
To illustrate, this figure from Report 2 uses these four formulas to return data about Rome:
K9: =" "&F!UnitsLabel
If you changed "F" to "K" in these four formulas,
Figure 4 would return information from sheet K, which initially has a
figure title of "Los Angeles".
In the small chart above, there's not room to display "Sep", "Nov", and so on. So the chart uses numbers to indicate the months. But larger charts do have room to use three-letter abbreviations for the months, as the following figure illustrates.
Each worksheet that supports a chart has two sets of formatted dates, as shown here:
If your charts' series formulas refer to the Month range like this...
...they'll display numbers in their X axis.
But if your series formulas refer to the AltMonth range, like this...
...they'll display the three-letter abbreviations for the the month in their X axis.
To change the formulas, just click on the line object and then the area object in a chart and change the SERIES formula to either Month or Altmonth.
Strictly speaking, only the first series formula needs to be changed.
But it's usually a good idea to change them both.
One minor frustration with Excel is that it doesn't automatically adjust the number format of the Y axis labels to their most efficient setting. These charts from Excel 2007 illustrate the problem.
In the left chart, the number format obviously needs to be changed. After all, we can't have repeating numbers in our Y-axis labels. The center chart shows how the values should be displayed.
The right chart shows the opposite problem. Having too many decimal values clutters the display and reduces the horizontal size of the chart.
We must correct this problem manually. To do so, select the Vertical axis. Press Ctrl+1 to launch the Format Axis dialog. In the Number tab, enter the number of decimal places you want, as a value. Then...