Results 1 to 3 of 3

Thread: Data labels not displayed correctly
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Jul 2019
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Data labels not displayed correctly

    I have a 3 series stacked bar chart and the fourth series is a data label. The data label is a date value that selects values from the date column. The Primary axis is categorized based on 2 values. The secondary axis is Month. The data labels are displayed accurately as per the month except the 3 labels.

    The first series is the difference between F and E.The second series is the difference between the J and K column. The third series is the difference between L and M column. The fourth series is a date column with the data label displayed on the stacked bar chart.

    The three data labels alone are not displaying below the exact Month and what might be the reason for this?

  2. #2
    Board Regular pbornemeier's Avatar
    Join Date
    May 2005
    Location
    Virginia Beach, VA USA
    Posts
    3,658
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Data labels not displayed correctly

    Could you upload an image to one of the sharing sites and post the link here. I cannot picture the problem based on what you said.
    Some data and the SERIES formulas would also help us to troubleshoot.

    Code:
    Option Explicit
    
    Sub PrintSeriesFormulae()
    
        Dim ser As Series
        
        For Each ser In ActiveSheet.ChartObjects(1).Chart.SeriesCollection
            Debug.Print ser.Formula
        Next
        
    End Sub
    Phil

    - Use CODE tags to keep your code formatted. See: BB Tags
    - How to attach Screenshots
    - Try searching for your answer first, see how
    - Test and validate results for all code on a copy of your worksheet!! How do you use the code you just found?
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

  3. #3
    New Member
    Join Date
    Jul 2019
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Data labels not displayed correctly

    Thanks for the reply. I will attach the excel sheet within few hours from now.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •