View Single Post
  #1   Report Post  
iconic83
 
Posts: n/a
Default overlay two graphs with different x axis


hi there i'm having trouble trying to overlay 2 graphs together, they
are shown below.

'cost graph'
(http://img398.imageshack.us/img398/4...stgraph7bj.jpg)

'phase graph'
(http://img382.imageshack.us/img382/9...segraph5oo.jpg)

the data used is shown he

'data' (http://img395.imageshack.us/img395/8226/data1vl.jpg)

for the cost graph, it is a standard line graph: y axis is I9:I24, x
axis is K9:K24

for the phase graph, it is a stacked column graph with a hidden data
series: y axis is stacked K3:K6 and L3:L6, and the x axis is G3:G6

is it possible to overlay these graphs together given the y axis are
the same

thanks!
peter


--
iconic83
------------------------------------------------------------------------
iconic83's Profile: http://www.excelforum.com/member.php...o&userid=26395
View this thread: http://www.excelforum.com/showthread...hreadid=401395