+ Reply to Thread
Results 1 to 2 of 2

can we combine line chart and colum chart in one chart

  1. #1
    Registered User
    Join Date
    04-01-2009
    Location
    Australia
    MS-Off Ver
    Microsoft Professional 2010 plus
    Posts
    55

    can we combine line chart and colum chart in one chart

    I have one spreadsheet, please see thea attached. I need to set up colum chart for revenue and the same time to put empolee count in line chart to express the trend. can I do that? if not , do you have good idea to express that?
    Attached Files Attached Files

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: can we combine line chart and colum chart in one chart

    You just need to add the series to the column chart, change the series to a line, and then plot the series on the secondary axis.

    Is this what you want?
    Attached Files Attached Files
    HTH
    Regards, Jeff

+ 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