+ Reply to Thread
Results 1 to 3 of 3

Variance graphs

  1. #1
    Registered User
    Join Date

    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
    United Kingdom
    MS-Off Ver
    EXCEL 2003 (2007 at home)

    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
    Essex, UK
    MS-Off Ver
    For xl2003 double click one of the lines. On the Format dialog, Series Options tab is the Up/Down bars option

+ 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


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