+ Reply to Thread
Results 1 to 3 of 3

how to overlay line graph over a bar chart

  1. #1
    Registered User
    Join Date
    10-16-2006
    Location
    Western MA
    Posts
    11

    how to overlay line graph over a bar chart

    hi all,
    is this even possible? if so, how so?
    or, can you have 3 sets of data and choose a combination of how to display it?
    thanks for any help!
    ~judi

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,802

    Re: how to overlay line graph over a bar chart

    I will answer with a cautious "Yes, I think almost anything is possible with enough time, effort, and skill." You have not given much detail, though, so it is hard to know exactly what you are after.

    Sometimes we use "bar" a little loosely. Technically "bar" charts refer to horizontally oriented bars, and a "column" chart refers to vertically oriented bars, though we sometimes say "bar" when we mean "column".

    If I assume that you mean "bar" + line combination, then I will point you to this tutorial: http://peltiertech.com/Excel/Charts/BarLineCombo.html

    If you meant "column" + line combination, that should be even easier, simply change the chart type of the "line" series from column to line.
    Last edited by MrShorty; 03-07-2016 at 04:13 PM.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Registered User
    Join Date
    10-16-2006
    Location
    Western MA
    Posts
    11

    Re: how to overlay line graph over a bar chart

    ty for answering so quickly.
    it was your first inclination: a bar and line combo.
    i found info here:
    https://support.office.com/en-us/art...8-4ffafe2a1080

+ 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. How can I neatly overlay a line graph series over a scatter plot?
    By dmasters4919 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-03-2015, 05:51 PM
  2. [SOLVED] 3 axis chart with stacked bar graph and line graph above
    By hefe_espada in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 06-26-2013, 12:53 PM
  3. How overlay 5 hours of bar chart data onto 24 hours of line chart data
    By oldtauntonian in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 04-15-2013, 05:21 AM
  4. [SOLVED] Overlay Line Chart onto a Stacked Bar Chart
    By samuelll101 in forum Excel General
    Replies: 4
    Last Post: 11-22-2012, 10:26 AM
  5. 3rd Axis Line Graph Overlay Data Set Problem
    By joe.teixeira in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 10-11-2011, 03:26 AM
  6. How to combine one segmented column graph with line graph in one chart
    By hamood83 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 07-26-2007, 03:19 AM
  7. Overlay %change on bar graph??? :(
    By fh2level in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-04-2006, 09:55 AM

Tags for this Thread

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