Results 1 to 2 of 2

Trying without success to add a Goal line in a chart

Threaded View

  1. #1
    Forum Contributor
    Join Date
    05-12-2021
    Location
    USA
    MS-Off Ver
    Microsoft Office 365
    Posts
    259

    Trying without success to add a Goal line in a chart

    Hello, as the title says, I am trying to get a "GOAL" Line to display in several different charts. There are a total of 15 different charts - 5 per Department. Each chart represents data of the following categories across a 6 week period:

    *Let Down
    *Loading
    *Order Selection
    *Put Away
    *Receiving

    There are 6 different tabs - 3 Department chart tabs and 3 Department Data tabs. The Chart tabs pick up select data from the Data tabs which ultimately is what is displayed in the charts. On each chart tab, in columns J and K, that is the Goal column for each category in the departments. Most have 95 as their goal and one has 100. I've been asked to implement this Goal Line into each chart but I have no idea how to do it based on the layout that I have as I am really not familiar with charts overall as I seldom have to use them.

    I have attached the file without the macros for a little more simplicity. Any help is always appreciated!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Excel Chart Goal Line Display As Percent
    By revocats10 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 10-02-2021, 05:20 AM
  2. Combo chart - Clustered Column & Line for goal
    By suudlej in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-05-2018, 03:03 PM
  3. Adding 50% horizontal goal line to pivot chart
    By pravly in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 02-05-2014, 05:09 AM
  4. Replies: 3
    Last Post: 12-01-2013, 06:11 PM
  5. Line Chart & Goal Seek
    By David Brown in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 11-28-2011, 04:32 AM
  6. [SOLVED] How do I add a goal line to a stacked bar chart in excel?
    By rheinzy in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 05-19-2006, 08:30 PM
  7. Goal Line in chart but not on data tabel
    By BMSpell in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-01-2005, 03:06 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