combine Column & line charts

C

C

I am trying to create a chart that shows Total AR as a column and % over 30 &
over 60 as lines. I've tried to use the Line-Column but it only plots one
of the % data and not both.
 
J

Jon Peltier

Those "built-in custom" charts are a pain.

Make a column chart with all three series. Select the Over 30 series, and
use Chart menu > Chart Type to change it to a line type. Repeat this for the
Over 60 series. If you want the percentages on the secondary axis, double
click the Over 30 series, and on the Axis tab, choose Secondary. Repeat for
the Over 60 series.

- 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