+ Reply to Thread
Results 1 to 3 of 3

creating a line graph

  1. #1
    Registered User
    Join Date
    10-19-2012
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2003
    Posts
    4

    creating a line graph

    How can I create a line graph with the data below given with the different quarters (quarter 1, quarter 2, quarter 3, quarter 4) on the x-axis and one line for Revenue, one line for COGS, one line for EBITA? I have attached excel file.total.xls

    Please help.

  2. #2
    Registered User
    Join Date
    08-29-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    7

    Smile Re: creating a line graph

    want to creating a line graph, see below code, this code is not the line chart according to your file.you can know the method from it.

    Please Login or Register  to view this content.
    Then you can create chart data:
    Please Login or Register  to view this content.
    then, eidt chart data region,position and data:
    Please Login or Register  to view this content.
    if you are still not very clear, you can visit this technical article:excel line chart c#

    Hope it help you!

  3. #3
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,482

    Re: creating a line graph

    select the range
    =Sheet1!$C$1:$F$1,Sheet1!$C$11:$F$11,Sheet1!$C$17:$F$17,Sheet1!$C$20:$F$20

    Insert Line chart.
    Cheers
    Andy
    www.andypope.info

+ 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