+ Reply to Thread
Results 1 to 8 of 8

2 values stacked, 3rd value plotted as line

  1. #1
    Registered User
    Join Date
    02-05-2007
    Posts
    6

    2 values stacked, 3rd value plotted as line

    I'm trying to build a chart with three values for each month. I'd like to stack two of them, and plot the third value as a line. I'll be using only one Y axis. Any ideas?

  2. #2
    Forum Expert oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Home)
    Posts
    7,097
    Does anything here help?

    http://peltiertech.com/Excel/Charts/....html#ComboCht
    oldchippy
    -------------


    Blessed are those who can give without remembering and take without forgetting

    If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.

    Click here >>> Top Excel links for beginners to Experts

    Forum Rules >>>Please don't forget to read these

  3. #3
    Registered User
    Join Date
    02-05-2007
    Posts
    6

    Some great stuff, but...

    still doesn't give me the chart I need. I need to create a combination bar and line chart, but the bar chart is stacked with two different values.

  4. #4
    Forum Expert oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Home)
    Posts
    7,097
    How about this, can't you do a stacked column and a line?

    http://www.j-walk.com/ss/excel/usertips/tip078.htm

  5. #5
    Registered User
    Join Date
    02-05-2007
    Posts
    6

    I'm able to...

    Create the stacked bar chart, but when i select the series I want to plot as a line over my existing stacked bar chart, it wants to create a separate chart. Any ideas?

  6. #6
    Forum Expert oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Home)
    Posts
    7,097
    I followed the last links instructions and got this?
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    02-05-2007
    Posts
    6

    Thanks!

    I got it to work

  8. #8
    Forum Expert oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Home)
    Posts
    7,097
    Quote Originally Posted by more_Qs_than_As
    I got it to work
    If at first you don't succeed, try, try, try again - glad you're sorted - thanks for the feedback

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1