Specifying chart graph
 

How can I specify on the same chart which fields I want to be displayed as
Column and which fields I want to be displayed as Line? I have over seven
fields. Let's say I want columns B through E to be columns and the other
columns to be lines. Thanks in advance.

Specifying chart graph
 

Forget about the built-in custom types. Make a column chart. Then select a
series you want to change to a line, choose Chart Type from the Chart menu,
and choose a line style. Select another you want to change and press the F4
function key, and repeat as required.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"SJ" wrote in message
...
How can I specify on the same chart which fields I want to be displayed as
Column and which fields I want to be displayed as Line? I have over seven
fields. Let's say I want columns B through E to be columns and the other
columns to be lines. Thanks in advance.