+ Reply to Thread
Results 1 to 12 of 12

How to make 2 kinds of charts in 1 chart ? (Column & Line) please :D

  1. #1
    Registered User
    Join Date
    05-23-2013
    Location
    Jakarta, Indonesia
    MS-Off Ver
    Excel 2007
    Posts
    4

    How to make 2 kinds of charts in 1 chart ? (Column & Line) please :D

    here the example picture :

    untitled-1369364475.jpg

    please teach me to make that charts, that charts is proposed to make Working Progress on my company

    thanks
    Last edited by Raruku; 05-23-2013 at 11:04 PM.

  2. #2
    Forum Contributor
    Join Date
    12-11-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    232

    Re: How to make 2 kinds of charts in 1 chart ? (Column & Line) please :D

    Create a bar chat with 2 data series for the same data.
    click on one of the series and make it a line chart.

    format everything you don't need away

    done

  3. #3
    Registered User
    Join Date
    05-23-2013
    Location
    Jakarta, Indonesia
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: How to make 2 kinds of charts in 1 chart ? (Column & Line) please :D

    how to make 2 series for the same data?

    i dont get it , btw thanks for your fast response !

  4. #4
    Forum Contributor
    Join Date
    12-11-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    232

    Re: How to make 2 kinds of charts in 1 chart ? (Column & Line) please :D

    Do you know how to create a chart?

  5. #5
    Registered User
    Join Date
    05-23-2013
    Location
    Jakarta, Indonesia
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: How to make 2 kinds of charts in 1 chart ? (Column & Line) please :D

    sorry for the long response, i had a great weekend :D

    here's my work know : http://speedy.sh/HG24K/Tabel.xlsx

    i know how to create a single chart either combination chat, but i dont know how to make it to be the chart on my #1 post

  6. #6
    Forum Contributor
    Join Date
    12-11-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    232

    Re: How to make 2 kinds of charts in 1 chart ? (Column & Line) please :D

    Ok I clearly overshot my opinion on how easy your chat is. I tried to create that chart with your data, but it kicked my butt too. I can not find another example of how that was done. I hope a pro pops in here and set us both straigt. I'm sorry I could't solve your issue.
    Last edited by nemo74; 05-28-2013 at 11:57 AM.

  7. #7
    Forum Contributor
    Join Date
    11-11-2012
    Location
    Muscat, Oman
    MS-Off Ver
    Office 365
    Posts
    521

    Re: How to make 2 kinds of charts in 1 chart ? (Column & Line) please :D

    Please check the attached file and let me know if this is what you are looking for.
    Best Regards/VKS
    Attached Files Attached Files

  8. #8
    Forum Contributor
    Join Date
    12-11-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    232

    Re: How to make 2 kinds of charts in 1 chart ? (Column & Line) please :D

    VKS did you look at the OP 1st post picutre?

  9. #9
    Forum Contributor
    Join Date
    11-11-2012
    Location
    Muscat, Oman
    MS-Off Ver
    Office 365
    Posts
    521

    Re: How to make 2 kinds of charts in 1 chart ? (Column & Line) please :D

    I was getting a grey box with red X inside. Hence posted a suggestion. If its way off i can delete it......

  10. #10
    Forum Expert
    Join Date
    09-20-2011
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    2,278

    Re: How to make 2 kinds of charts in 1 chart ? (Column & Line) please :D

    Hello
    Not sure if you're still looking for a possible solution but take a look at the attached example. Is this the chart you wish to create?

    Hope this helps.
    DBY
    Attached Files Attached Files
    Last edited by DBY; 05-29-2013 at 02:12 PM. Reason: Amended Chart

  11. #11
    Forum Contributor
    Join Date
    12-11-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    232

    Re: How to make 2 kinds of charts in 1 chart ? (Column & Line) please :D

    Hey DBY,
    I don't know where the OP went, but you chart is spot on to what he was asking.

    I'll be keeping that infor around. I couldn't get that to work. Good job! I would mark this as solved if I could. I'll give you some rep myself for coming through

  12. #12
    Forum Expert
    Join Date
    09-20-2011
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    2,278

    Re: How to make 2 kinds of charts in 1 chart ? (Column & Line) please :D

    Thank you nemo74, very much appreciated. I figured the OP might not return but as I'd worked it through I thought I'd post it as others might find it useful.

    Regards DBY

+ 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