Specifying chart graph

S

SJ

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

Jon Peltier

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top