+ Reply to Thread
Results 1 to 4 of 4

legend in a charting

  1. #1
    Forum Contributor
    Join Date
    10-31-2018
    Location
    venezia
    MS-Off Ver
    2007
    Posts
    481

    legend in a charting

    Hello,
    I ask for help to update the chart in the "grafico_input" sheet
    In the graph it is possible that in the white part on the right
    display a legend in this way:
    the horizontal axis with the description

    number description
    1 AAAAAAAAAAAAAAAAAA
    2 BBBBBBBBB
    3 CCCCCCCCCCCC
    4 DDDDDDDDDDDDDDDDD
    5 EEEEEEEEEEEEEEEE
    6 FFFFFFFFFFFFFFFFF
    7 GGGGGGGGGGGGGGGG
    8 HHHHHHHHHHHHHH
    9 IIIIIIIIIIIIIIIIIIIIIIIIIIIII
    10 LLLLLLLLLLLLLLLLLLL
    11 MMMMMMMMMMMM
    12 NNNNNNNNNNNNNN
    13 OOOOOOOOOOOOOO
    14 PPPPPPPPPPPPPPPPPP
    15 QQQQQQQQQQQ
    16 RRRRRRRRRRRRRRRRRR
    17 SSSSSSSSSSSSSSSSSSSS
    18 TTTTTTTTTTTTTTTTTT
    19 UUUUUUUUUUUUUUUU
    20 VVVVVVVVVVVVVVVV

    the description of the legend must be connected at the range D31:D50
    I hope I explained myself
    john
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    10-31-2018
    Location
    venezia
    MS-Off Ver
    2007
    Posts
    481

    Re: legend in a charting

    I solved in part by adding some text boxes for each number connected to the cells
    but it's not a good job, other alternatives?
    Attached Files Attached Files

  3. #3
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,803

    Re: legend in a charting

    Is there a reason you are not using column D as the category axis labels and have the text directly underneath the columns? If you are unsure how to edit the chart to do so:
    1) Select the chart
    2) Bring up the Select data dialog
    3) Under "Horizontal category axis labels" click Edit
    4) Select D31 to D50. click okay until you are back to the chart.
    5) If necessary, Select the horizontal axis -> format axis -> rotate the label text so it is easier to read.

    Will that work for you?
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  4. #4
    Forum Contributor
    Join Date
    10-31-2018
    Location
    venezia
    MS-Off Ver
    2007
    Posts
    481

    Re: legend in a charting

    Hi MRshorty
    I had tried your solution but the text is too much
    long for this I was looking for something alternative
    to my solution.
    My legend is a series of linked text boxes
    at the D31: D50 range
    Attached Files Attached Files

+ 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. [SOLVED] Legend?
    By bamma86 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-30-2012, 04:56 PM
  2. Legend
    By NAS in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 12-01-2005, 12:16 PM
  3. Legend - Don't Want To See
    By Bob Barnes in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 10-07-2005, 06:05 PM
  4. [SOLVED] Legend
    By Alison in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 06-17-2005, 07:05 PM
  5. Custom charting - Stacked charting with a line
    By Randy Lefferts in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 03-03-2005, 12:06 AM
  6. [SOLVED] legend
    By gunhild in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-15-2005, 12:06 AM
  7. how do you do a legend?
    By Andicat1627 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-01-2005, 07:00 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