Combination Chart- 1 Column, 2 Lines

T

threee11

I am attempting to create a combination chart that uses one column, but 2
lines. I want the column to represent a percentage and the lines to show
pricing at two different locations. Everything I see allows me to do the
opposite (2 columns, 1 line).
Any advice?
 
J

Jon Peltier

Ignore the built-in custom types. Besides being oxymoronic, they are just
not flexible. Make your own combination chart as follows:

Make a line chart with all of the data. Right click on the one series you
want as a column, choose Chart Type from the pop up menu, and choose a
suitable series type.

- 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