+ 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
    129

    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
    O365
    Posts
    20,419

    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)

Similar Threads

  1. Pivot Chart Radar Chart Labels Problem
    By jancliff in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 12-12-2021, 12:11 AM
  2. [SOLVED] move bar chart axis to center of chart with labels to left
    By mysticmoron109 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 02-27-2019, 09:45 AM
  3. Adding Horizontal Axis Labels to Chart without Selecting the chart
    By Jonathan78 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-31-2017, 11:32 AM
  4. [SOLVED] Adding Horizontal Axis Labels to Chart without Selecting the chart
    By Jonathan78 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-26-2017, 04:02 PM
  5. Change chart/pivot table numeric labels to associated text labels
    By petschek in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-07-2014, 05:32 PM
  6. Bar Chart Labels
    By MeenuSaini in forum Excel General
    Replies: 0
    Last Post: 07-17-2010, 09:11 AM
  7. Chart labels disappear - How do I refresh the chart?
    By jcloydjcloyd in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 03-30-2006, 02:55 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