+ Reply to Thread
Results 1 to 2 of 2

Combine bar and line graphs

  1. #1
    Forum Contributor
    Join Date
    06-11-2008
    MS-Off Ver
    2003
    Posts
    220

    Combine bar and line graphs

    Please see attached.

    The graph which i have currently created shows the data of columns C-H, which show the bars.

    I want to add column I onto the graph but I want to show that as a line rather than a bar.

    Can you help me?

    Many thanks!!!
    Attached Files Attached Files

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

    Re: Combining bar and line graphs

    Extend the chart data range to include column I. This will add another section to the stacked columns.
    Right click new section and change chart type to Line.

    Having done that the Average line does not make much sense as only the first series in the stack is in a position to be compared to it.
    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