Microsoft Office Tutorials and References
In Depth Information
Third, you can copy an existing SERIES function as a new series,
and then modify it to meet your needs. To do so, select the Chart
Area, and then select a data series to copy. Select the entire
SERIES formula in the formula bar and then press the Ctrl-C key
combination to copy this formula to the clipboard. Select the Chart
Area again. Paste the copied formula into the formula bar, and then
modify the formula as needed.
Multiple Chart Types
One chart can display different chart types for different data series.
These new chart types can be linked to the primary value (Y) axis,
or to the secondary one.
Let’s consider each method.
Using the Primary Value Axis
The first figure at the right shows two data
series. The jagged line shows actual
spending; the smooth line shows budgeted
spending.
10
8
4
2
0
Jan
04
Apr Jul Oct Jan
05
Let’s display the budget as an area chart. To
do so, select the budget line in the first figure.
Choose Chart, Chart Type. In the Chart Type
dialog, choose the Area type and the top-left
chart sub-type.
10
8
4
0
Jan
04
Apr Jul Oct Jan
05
To format the area and border colors, select
the area data series. Choose Format,
Selected Data Series. Then assign the colors
you want in the Patterns tab of that dialog.
The second figure above uses colors that aren’t standard with
Excel. See ExcelUser.com for the article Display Any Colors in
Excel .
 
Search JabSto ::




Custom Search