Specifying chart graph

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

SJ - 14 Sep 2006 02:23 GMT

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.

Reply to this Message

Jon Peltier - 14 Sep 2006 04:34 GMT

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
_______

> 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.

Reply to this Message