+ Reply to Thread
Results 1 to 11 of 11

Disappearing Goal Line on Chart

  1. #1
    Registered User
    Join Date
    05-07-2022
    Location
    USA
    MS-Off Ver
    365
    Posts
    20

    Disappearing Goal Line on Chart

    I have a clustered bar chart with a goal line. When I chose to filter out some of the data on the chart using, my goal line is no longer present. The filtering I’m using is the Chart Filters button next to upper right hand side of the chart. How do I keep this goal line from disappearing when I filter?

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Disappearing Goal Line

    This is specific to how you have set up your data and your chart. Can you attach your file? See yellow banner at the top of the page.
    Jeff
    | | |·| |·| |·| |·| | |:| | |·| |·|
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    05-07-2022
    Location
    USA
    MS-Off Ver
    365
    Posts
    20

    Re: Disappearing Goal Line

    Attached is the sample. I didn't realize it didn't attach originally. Thank you.
    Attached Files Attached Files

  4. #4
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Disappearing Goal Line on Chart

    I filtered out everything except Goal and I still see your goal line. Can you be more specific about what causes it to disappear?

    goal.jpg

  5. #5
    Registered User
    Join Date
    05-07-2022
    Location
    USA
    MS-Off Ver
    365
    Posts
    20

    Re: Disappearing Goal Line on Chart

    When I filter out in the categories. So if I want to see only Emp 2, this is what I get.
    Attached Images Attached Images

  6. #6
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Disappearing Goal Line on Chart

    The Goal line goes through each selected employee. When there is only one employee, it collapses to a single point so you don't see it.

    Create two blank employees at either end and ensure that when you are filtering on employees, that these first and last blank employees are always selected in the filter.
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    05-07-2022
    Location
    USA
    MS-Off Ver
    365
    Posts
    20

    Re: Disappearing Goal Line on Chart

    Thank you, much appreciated.

  8. #8
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Disappearing Goal Line on Chart

    If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."

    If a member helped you solve your problem, consider adding to their reputation by clicking addreputationiconsmall.jpg below their name.

  9. #9
    Forum Expert
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B2016 & H&B2021
    Posts
    3,060

    Re: Disappearing Goal Line on Chart

    You may also turn on the marker option.

  10. #10
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Disappearing Goal Line on Chart

    Quote Originally Posted by josephteh View Post
    You may also turn on the marker option.
    True, but it would still be just a dot. Lines for goals are nice.

  11. #11
    Forum Expert
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B2016 & H&B2021
    Posts
    3,060

    Re: Disappearing Goal Line on Chart

    Agreed. Although the marker can be a line, however, not more than the width of a column.
    Last edited by josephteh; 12-24-2023 at 05:39 AM. Reason: the marker, not market

+ 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. Different Data types and Goal line in a chart
    By jomili in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 12-19-2023, 04:20 PM
  2. Trying without success to add a Goal line in a chart
    By PitchNinja in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-09-2022, 03:18 PM
  3. Disappearing Chart Line
    By K m in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 02-17-2014, 05:33 PM
  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] Line disappearing from chart after changing data source
    By Albert in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 07-12-2006, 07:20 AM
  7. [SOLVED] 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