+ Reply to Thread
Results 1 to 4 of 4

Axis labels not updating on chart created from table

  1. #1
    Registered User
    Join Date
    02-22-2021
    Location
    Scotland
    MS-Off Ver
    Excel 2016
    Posts
    2

    Axis labels not updating on chart created from table

    I have created a chart from a table in Excel 2016. I need this to be dynamic, and update when new information is added to the table.
    The x-axis has multiple labels, and the chart does not contain all of the columns in the table.
    If I add new row in the table, the data is populated on the chart, but the x-axis labels are blank (please see attached example sheet).
    If I include all of the table columns in a chart, the axis labels seem to update ok, but the real table is quite large, and I don't want to display all the data on one chart.

    Could you please advise what I can do to fix this? I know that I can use offset with named ranges to create the dynamic chart, but I'm wondering if there is a way to make this work just using a table. Many thanks.
    Attached Files Attached Files
    Last edited by cat20; 02-22-2021 at 12:27 PM. Reason: To mark solved

  2. #2
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent Monthly Channel / Insiders Beta
    Posts
    8,913

    Re: Axis labels not updating on chart created from table

    You could create a name, say ChartLabels, defined as: =Table1[[Area]:[Time]] and then use that name for the axis labels.
    Rory

  3. #3
    Registered User
    Join Date
    02-22-2021
    Location
    Scotland
    MS-Off Ver
    Excel 2016
    Posts
    2

    Re: Axis labels not updating on chart created from table

    Brilliant, that works well. Thanks very much.

  4. #4
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent Monthly Channel / Insiders Beta
    Posts
    8,913

    Re: Axis labels not updating on chart created from table

    Glad to help.

    I'm not sure why the labels don't work with multiple columns - seems like a bug to me.

+ 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 Table Chart not updating data labels?
    By kjnjanx in forum Excel General
    Replies: 3
    Last Post: 04-27-2019, 04:15 AM
  2. Updating Secondary X-Axis Labels
    By TimlmiT in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 08-10-2018, 05:18 PM
  3. Changing chart type & second axis on chart with 2-level axis labels
    By trolle in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 04-15-2016, 09:52 AM
  4. [SOLVED] Merged cells in table causing gaps between chart axis labels
    By OmniBlue in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-01-2014, 04:25 PM
  5. [SOLVED] X-Axis labels disappear when adding data table to chart
    By phacexcel in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 08-22-2012, 02:37 PM
  6. Replies: 1
    Last Post: 07-12-2012, 02:33 PM
  7. Chart axis labels not updating properly with VBA
    By d3hartm2 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-05-2009, 12:10 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