View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope Andy Pope is offline
external usenet poster
 
Posts: 2,489
Default two bars and a line on 2 axes

Hi,

Create your own combination chart by starting with a clustered column
chart. Then right click the column series you wish to change to a line.
From the context menu pick Chart Type. Choose the appropriate line chart.

Cheers
Andy

BorisS wrote:
Need a custom chart with 2 vertical bars side by side, on one axis, and a
line on a second axis. Anyone know the series of steps I need? I was having
trouble figuring out the order of what set of the three data goes where, and
how to define which of the pieces is on bar and which is on line, and which
is second axis, etc.

Thanks for any help.