+ Reply to Thread
Results 1 to 5 of 5

Legend displays X axis labels instead of Data Series label when one bar color is changed

  1. #1
    Registered User
    Join Date
    11-10-2011
    Location
    NH
    MS-Off Ver
    Excel 2010
    Posts
    2

    Legend displays X axis labels instead of Data Series label when one bar color is changed

    Using Excel 2010. I create a bar chart using data in a worksheet. If I add a legend, the legend displays the "Series Name" from the "Legend Entries (Series). By default, all bars have the same fill color. If I change the fill color of one of the bars, the legend changes to display the X axis labels, the "Horizontal (Category) Axis Labels". If I do not display a legend I can change the colors of the bars with no additional side effects. Does anyone know how to turn this automatic change off? I want to display the Series Name, not the X axis labels (they are already clearly displayed on the bottom of the chart.
    Thanks for any assistance with this.

  2. #2
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Legend displays X axis labels instead of Data Series label when one bar color is chang

    I think you have to delete the legend and replace it with a textbox
    Josie

    if at first you don't succeed try doing it the way your wife told you to

  3. #3
    Registered User
    Join Date
    11-10-2011
    Location
    NH
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Legend displays X axis labels instead of Data Series label when one bar color is chang

    I can do that but then I have lost the automation - if I change the data series label in the spreadsheet I then need to change the chart(s). After creating charts in Excel I then copy them to a PP presentation which is then linked to the chart in Excel. I do a lot of this work and need to have the links working in the chart/data/label selection process.

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

    Re: Legend displays X axis labels instead of Data Series label when one bar color is chang

    I don't believe you can control it. If you need the legend then add another series to the chart and format it such that it does not appear. You can even remove it from the legend if you want to.

    How do you tell the reader of the chart what the variations in column colours actual means?
    Cheers
    Andy
    www.andypope.info

  5. #5
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Legend displays X axis labels instead of Data Series label when one bar color is chang

    you can link the textbox to a cell so it updates just as the series name would

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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