+ Reply to Thread
Results 1 to 2 of 2

Labels on a chart

  1. #1
    Forum Contributor
    Join Date
    04-14-2009
    Location
    Wales
    MS-Off Ver
    Excel 2010
    Posts
    128

    Labels on a chart

    Hi all,

    Please see attached spreadsheet as example. I want the chart to be dynamic, but as I select a load of blank cells, it shows a number instead of the field name. It will only pull through the field name if i select cells with data in them. I dont want to keep going back and changing the area for the graph, is there a way of automating that?

    All help would be appreciated.

    Thanks,

    Om
    Attached Files Attached Files

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    2003, 2007, 2010 & 2013
    Posts
    18,770

    Re: Labels on a chart

    The chart is displaying 1,2,3 etc. because you have not provided any range for it to use as category labels.
    Select the chart and then use the Select Data dialog to select the Horizontal axis range.

    If you want the chart to only show valid data then use a table. Or named ranges to define chart data and labels.
    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)

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