Results 1 to 3 of 3

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

Threaded View

nscarritt Creating a line graph over a... 04-03-2014, 12:07 PM
Kaper Re: Creating a line graph... 04-03-2014, 01:12 PM
nscarritt Re: Creating a line graph... 04-03-2014, 03:09 PM
  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.

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