LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Secondary Axis Match Primary Axis Gridlines [email protected] Charts and Charting in Excel 1 July 31st 05 09:23 PM
Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis [email protected] Charts and Charting in Excel 0 July 13th 05 09:30 PM
How do I specify using lines or bars on graphs w/ 2nd value axis? Motorhead Charts and Charting in Excel 1 June 22nd 05 08:41 PM
How do I put multiple graphs on one axis? TheDud Charts and Charting in Excel 1 April 11th 05 04:22 AM
Labels on Chart with Negative Value Axis David F. Schrader Charts and Charting in Excel 6 December 17th 04 06:25 PM


All times are GMT +1. The time now is 10:10 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"