+ Reply to Thread
Results 1 to 2 of 2

Formatting Labels in a Graph

  1. #1
    Registered User
    Join Date
    10-24-2019
    Location
    Montreal
    MS-Off Ver
    2016
    Posts
    1

    Formatting Labels in a Graph

    Hello Everyone,

    I am using a table to generate the bar graph which works on a slicer selection of Week.
    I am showing the total count on the top of the graph, however the label position keeps on changing , i selected the Label Position as "Above" from its properties, but still label position is not consistent
    Attached is my file. please suggest how to fix the label position so it is always in a symmetrical position on top of each bar.
    Attached Files Attached Files
    Last edited by Pepe Le Mokko; 10-25-2019 at 02:53 AM. Reason: Title amended - It is evident you are here for help. No need to add it in the title

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

    Re: Formatting Labels in a Graph

    Move the Count series to the secondary axis.
    Add secondary horizontal axis and set the Count series to use the data values as axis labels.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

+ 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. Replies: 0
    Last Post: 06-18-2019, 12:14 PM
  2. Replies: 1
    Last Post: 06-21-2017, 08:46 AM
  3. Graph - Data Labels - Number Formatting
    By Pulgasari in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 06-22-2016, 03:47 PM
  4. [SOLVED] Need graph to show alphanumeric values as Y axis labels with Date as Z axis labels
    By Ochimus in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 06-24-2015, 08:40 PM
  5. Replies: 0
    Last Post: 10-03-2014, 07:51 AM
  6. Replies: 2
    Last Post: 04-05-2014, 06:46 PM
  7. Excel 2007 : Bar Graph value labels
    By HarvardMajesty in forum Excel General
    Replies: 1
    Last Post: 03-01-2011, 05:58 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