+ Reply to Thread
Results 1 to 3 of 3

Creating a line graph over a bar graph to show actual v.s. goal?

  1. #1
    Registered User
    Join Date
    12-19-2013
    Location
    Kansas City
    MS-Off Ver
    Office 2010
    Posts
    42

    Creating a line graph over a bar graph to show actual v.s. goal?

    I am trying to find a way to create a line graph over a bar graph to show actual v goal in the same chart. The actual numbers are bars, where goals will be the line. Each program has its own goal, and the goal may be changed so I am looking to have a live chart as opposed to super-imposed 'draw' lines on the graph.

    I am attaching a worksheet with a basic example of what I'm looking for, but using the draw tool. +1's for all who help, I'd really appreciate it!

    Goal Line.xlsx
    Last edited by nscarritt; 04-03-2014 at 03:09 PM.

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often 365, but still time to time use also older versions
    Posts
    8,148

    Re: Creating a line graph over a bar graph to show actual v.s. goal?

    Add a new series (your column with Goal).
    It looks like second bar for each category.
    Right click on this series (it is important that only this new series is selected) and select change graph type.
    Select line graph.

    Ready.

    See attachment (lower graph).
    Attached Files Attached Files
    Last edited by Kaper; 04-03-2014 at 04:03 PM. Reason: wow, such a short text and I did 4 typos :(
    Best Regards,

    Kaper

  3. #3
    Registered User
    Join Date
    12-19-2013
    Location
    Kansas City
    MS-Off Ver
    Office 2010
    Posts
    42

    Re: Creating a line graph over a bar graph to show actual v.s. goal?

    Thank you Kaper.. you explained it MUCH more easily than resources I found via a google search. You're awesome!

+ 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. Line Graph (Actual plus forecast data)
    By arun2681 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 07-28-2012, 06:49 PM
  2. [SOLVED] How do I set a goal line in a bar graph?
    By mtwelsh72 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 03-19-2011, 09:35 AM
  3. Adding a Goal Line in Pivot Bar Graph
    By coolzero in forum Excel General
    Replies: 2
    Last Post: 01-19-2011, 01:21 PM
  4. Setting a Goal Line in a Graph
    By avidcat in forum Excel General
    Replies: 2
    Last Post: 11-19-2010, 10:45 AM
  5. Goal Line in Bar Graph - Can't get it to work
    By bg18461 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-03-2008, 01:37 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