+ Reply to Thread
Results 1 to 6 of 6

Excel Bar Chart not displaying the datapoint markers

  1. #1
    Registered User
    Join Date
    05-10-2014
    MS-Off Ver
    Excel 2003
    Posts
    3

    Excel Bar Chart not displaying the datapoint markers

    Hi All,

    I'm struggling with an issue whereby excel does not display all the datapoint markers for all the months in a series. For some strange reason, its skips some months and shows other months. I've tried to determine the reason to no avail please help

    I've attached the screenshot of this issue: Note that July, Oct, Jan are the areas with the issue. Thanks All

    I've added a worksheet to enumerate this further. Thx
    Attached Files Attached Files
    Last edited by Jamiu; 05-10-2014 at 10:15 AM. Reason: modificaiton

  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: Excel Bar Chart not displaying the datapoint markers

    Sorry but a screenshot is useless for this question. Wouldn't it be easier to just attach the actual Excel file, instead of pasting a screenshot into another Excel file?
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    05-10-2014
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Excel Bar Chart not displaying the datapoint markers

    I've added a worsheet to make it clearer

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,434

    Re: Excel Bar Chart not displaying the datapoint markers

    So what's the actual issue?

    For data series with many data points excel decides not to render selection indication for every data point. That does not mean the data is missing or the data will not be affect when you format the series.
    Cheers
    Andy
    www.andypope.info

  5. #5
    Registered User
    Join Date
    05-10-2014
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Excel Bar Chart not displaying the datapoint markers

    Thanks Andy!

    I quite understand that it does not impact the data, but i'm just curious as to why excel does not display the data selector in some months. My boss does a high level check on my presentation files and he uses that as one of the checks and complains about it even though i've tried to explain the fact that the accuracy of the data isnt an issue.

  6. #6
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,434

    Re: Excel Bar Chart not displaying the datapoint markers

    Your boss should get the range highlighted when a series is selected rather than whether each data point has a selection indicator.
    Or better yet check the range references via select data dialog.

+ 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. Excel scatter chart - markers
    By Prue in forum Excel Charting & Pivots
    Replies: 17
    Last Post: 10-01-2015, 09:30 AM
  2. Excel changes empty chart w/o markers to chart w/ markers
    By Dante_Blake in forum Excel General
    Replies: 1
    Last Post: 09-28-2011, 04:17 PM
  3. Beating the 32,000 datapoint chart limit
    By sweep in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-09-2009, 11:57 AM
  4. [SOLVED] Excel should allow correlations of data so chart markers match up
    By TLC in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-11-2006, 10:10 AM
  5. Replies: 2
    Last Post: 08-02-2006, 11:10 AM

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