+ Reply to Thread
Results 1 to 3 of 3

Variance graphs

  1. #1
    Registered User
    Join Date
    01-29-2008
    Posts
    3

    Variance graphs

    I am trying to make two series on a line graph but want to include the difference of the two series as a bar chart. The starting point of the bar should be the series with less value such that the bar is within the two charts...I hope this makes sense. Is there a way to do this?

  2. #2
    Forum Contributor
    Join Date
    10-27-2006
    Location
    United Kingdom
    MS-Off Ver
    EXCEL 2003 (2007 at home)
    Posts
    517

    Up/Down Bars

    I have just started using EXCEL 2007 and I can't remember seeing this feature in my old version but...

    under chart tools/layout/analysis there is a feature called "Up/Down Bars" which seems to be exactly what you want.

    If you are using an older version try searching the help pages for these terms, you might find that the same features are available via a different route.

  3. #3
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,431
    For xl2003 double click one of the lines. On the Format dialog, Series Options tab is the Up/Down bars option
    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)

Similar Threads

  1. Drop down menu to show different graphs
    By thinkvision12 in forum Excel General
    Replies: 0
    Last Post: 09-19-2008, 01:10 PM
  2. creating multiple graphs quickly
    By kingy in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 06-26-2008, 10:47 AM
  3. Replies: 2
    Last Post: 02-03-2008, 06:34 PM
  4. Graphs not refreshing
    By camt in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 09-15-2007, 07:32 AM
  5. Generating graphs automatically
    By IrfanB in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-30-2007, 04:51 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