View Single Post
  #4   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,
I don't quite understand what's going wrong. Possibly something to do with
your data layout. Could you post or email an example, and I'll look at it for
you?

Dave

"Fayez" wrote:

Thank you Dave,
I did that, but the problem when I combine the column (instead of bar). It
post the data for example with the right or secondary scale, but in reveres
order. It is somewhat complicated to explain, but let me try. It post the
left hand side line chart to read from left to right. Now the coulmn chart
reads from right to left. as well it reversed the data, possitive vs.
negative as well.

i hope expalined it right.

"Dave Curtis" wrote:

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.