+ Reply to Thread
Results 1 to 2 of 2

parent text label and expanded text label in a graph

  1. #1
    Registered User
    Join Date
    08-30-2009
    Location
    melbourne
    MS-Off Ver
    Excel 2016 / 2019
    Posts
    84

    parent text label and expanded text label in a graph

    Hi all,

    I am trying to display text in y-axis. It worked as I wished when displaying parent text. (see attached 'before expanded')
    However, when i expand it, the text label in a graph become strange in a way that parent text rotated to 90 deg while sub text show ok (see attached 'after expanded').

    Is there any way to display parent text and sub text at the same angle in the graph?

    Thank you for your help in advance.
    Attached Images Attached Images

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

    Re: parent text label and expanded text label in a graph

    Only in inner most layer of category labels will display horizontally in a bar chart.

    A column chart will display both horizontally but the amount of space available for each category will be limited.
    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. To multiply the % of parent total of a Row label with another field
    By lianweiling in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 03-08-2018, 01:12 PM
  2. Linking a text label to each stack in a stacked graph
    By mucbeanz in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 01-13-2016, 08:39 PM
  3. With a move label macro, prevent label from moving onto another label
    By SocratesJC in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-09-2014, 12:34 AM
  4. Missing label text in rectangle graph with varying width
    By Jan Rennel in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-25-2014, 04:03 AM
  5. How to peg a text box label to a data point on a line graph?
    By MCunningham in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 08-07-2013, 06:20 AM
  6. How can I sort by non-Parent Row Label field in a Pivot Table?
    By mwatsonca in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-09-2013, 02:40 PM
  7. Y-Axis Text Label
    By kcasey1318 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 10-11-2010, 08:58 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