View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Dave Curtis[_2_] Dave Curtis[_2_] is offline
external usenet poster
 
Posts: 99
Default how to combine two chart type in one graph

Hi,

Add both series as the same chart type, say line chart, then select one of
the series, and change the chart type to bar (column), and select it's axis
as secondary.
You may wish to adjust the scales of each of the axes to make the grid
lines, if any, look ok.

Dave

"Fayez" wrote:

How to combine two charts type in one graph. I am trying to creat a line
chart and a bar chart in one graph. One with the main axix and the other
using the secondary axis.