+ Reply to Thread
Results 1 to 3 of 3

How to create line chart with bar chart combo to show for deviation

  1. #1
    Registered User
    Join Date
    07-08-2019
    Location
    Toronto
    MS-Off Ver
    Office 365
    Posts
    25

    How to create line chart with bar chart combo to show for deviation

    Hi All,

    Unsure if this is possible but is there a way to show a line chart as an average of a sample and then a bar chart that shows deviation from the line as shown in the image below:

    chart idea.jpg

    Thanks in advance!
    Last edited by method90; 12-16-2019 at 11:05 AM.

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

    Re: How to create line chart with bar chart combo to show for deviation

    You could use Error bars with custom values. The bars start out as lines, but if you increase the line weight they will look like columns.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    07-08-2019
    Location
    Toronto
    MS-Off Ver
    Office 365
    Posts
    25

    Re: How to create line chart with bar chart combo to show for deviation

    Thanks, this worked.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 10-29-2015, 10:58 AM
  2. [SOLVED] Chart Lengend to show marker style on hidden line - Line chart
    By etaf in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 08-22-2013, 05:19 PM
  3. Line chart values shows deviation from real data
    By ssshnitco in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-07-2013, 04:32 PM
  4. Replies: 3
    Last Post: 04-07-2013, 07:40 AM
  5. Replies: 2
    Last Post: 06-15-2012, 03:06 AM
  6. Stock chart - combo of line and bar chart
    By cw56 in forum Excel General
    Replies: 2
    Last Post: 11-15-2010, 06:19 AM
  7. [SOLVED] Create a combo chart with two of the same chart types
    By Mark Parent in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 10-13-2005, 09:05 PM

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