LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 65
Default Combine 2 Charts 2007 Excel

I have a line chart (looks like an S curve graph) with two rows of data below
& this chart looks exactly like I want it to.
Period % Complete
Dec-04 7%
Jan-05 9%
Feb-05 10%
Mar-05 12%
Apr-05 14%
May-05 19%
Jun-05 22%
Jul-05 23%
Aug-05 24%
Sep-05 26%
Oct-05 28%
Nov-05 32%
Dec-05 36%
Jan-06 40%
Feb-06 45%
Mar-06 50%
Apr-06 55%
May-06 59%
Jun-06 63%
Jul-06 66%
Aug-06 71%
Sep-06 75%
Oct-06 78%
Nov-06 81%
Dec-06 85%
Jan-07 87%
Feb-07 89%
Mar-07 91%
Apr-07 93%
May-07 94%
Jun-07 94%
Jul-07 95%
Aug-07 95%
Sep-07 95%
Oct-07 95%
Nov-07 95%
Dec-07 95%
Jan-08 95%
Feb-08 95%
Mar-08 95%
Apr-08 95%
May-08 100%
Jun-08 100%
Jul-08 100%
Aug-08 100%
Sep-08 100%
Oct-08 100%
Nov-08 100%
Dec-08 100%
Jan-09 100%
Feb-09 100%
Mar-09 100%
Next, I have more data that should be expressed as a bar chart or straight
lines, the data is below. I want these bars or lines to be on my line chart
(S curve graph). Each issue should appear as a line or bar. Each issue
should begine on its start date & end on its end date. This is the chart I
have not been able to create & once it is created I need to put it on the
line chart (S curve graph). Can both be put on one chart or must I make 2 &
how?

Issues Start End
Foundation Design 22-Dec-04 23-Aug-06
Stone Cladding 16-Nov-04 3-Jul-06
Security W & D 4-May-05 15-Dec-05
Vault Door 12-Sep-05 20-Jun-06
Atrium Bridge Enclosure 14-Dec-04 27-Jun-06
Interior Lighting Design 15-Feb-05 25-May-06
Lighting Controls 25-May-06 1-Jun-06
NOB Shades 7-Feb-06 1-May-06
Ext Lighting Design 15-Feb-05 7-Mar-06
Water Tank 12-Dec-05 1-Jan-06
Chg No1 W to D 18-Jan-06 18-Aug-06
Chg No 5 W to N02 30-Sep-05 3-Oct-05
Glazing 18-Oct-05 5-Sep-06
Bracnh Circuit Wiring 21-Feb-06 17-Jul-06
Louver Sched 6-Jun-05 26-Jul-06
Revise Perimtr Ltg 7-Mar-07 14-Jun-07
Sound Attenuators at NOX 27-Jan-08 3-Mar-09
Boiler Bypass 29-Nov-07 3-Mar-09

Any help is greatly appreciated.
 
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
HELP! HOW TO COMBINE CHARTS IN MS.EXCEL [email protected] Excel Discussion (Misc queries) 1 April 18th 08 05:39 PM
Cannot combine stock charts with other chart types in Excel 2007 rrr Charts and Charting in Excel 2 January 15th 07 06:40 PM
need to combine two charts Phill Costello Charts and Charting in Excel 0 February 19th 06 04:17 AM
Combine Charts Chi Charts and Charting in Excel 1 December 20th 05 05:23 PM
How do I combine two different charts? BG Charts and Charting in Excel 1 April 26th 05 03:49 AM


All times are GMT +1. The time now is 12:26 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"