View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Combination Chart- 1 Column, 2 Lines

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"threee11" wrote in message
...
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?