+ Reply to Thread
Results 1 to 4 of 4

Adding Horizontal Axis Labels to Chart without Selecting the chart

  1. #1
    Forum Contributor
    Join Date
    08-19-2009
    Location
    Netherlands, Amsterdam
    MS-Off Ver
    Excel 2010
    Posts
    585

    Adding Horizontal Axis Labels to Chart without Selecting the chart

    Hello all,

    the following code enables me to add data to my stacked column chart.
    The horizontal axis labels however are shown as numbers (1,2,3,4...)
    The column with the data that I would like to use as axis labels are in range D15:D18.
    Do you know how to add these labels to the chart without selecting it.

    Please Login or Register  to view this content.

  2. #2
    Forum Contributor
    Join Date
    08-19-2009
    Location
    Netherlands, Amsterdam
    MS-Off Ver
    Excel 2010
    Posts
    585
    Anyone..........?

  3. #3
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Adding Horizontal Axis Labels to Chart without Selecting the chart

    Perhaps thus
    Please Login or Register  to view this content.
    Don
    Please remember to mark your thread 'Solved' when appropriate.

  4. #4
    Forum Contributor
    Join Date
    08-19-2009
    Location
    Netherlands, Amsterdam
    MS-Off Ver
    Excel 2010
    Posts
    585

    Re: Adding Horizontal Axis Labels to Chart without Selecting the chart

    That worked just great.
    Thanks for sharing your knowledge!

+ 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. 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
  2. Adding horizontal (category) axis labels on an X-Y scatter plot
    By chetanchimate in forum Excel General
    Replies: 6
    Last Post: 01-01-2016, 11:40 PM
  3. Replies: 3
    Last Post: 04-30-2014, 05:57 AM
  4. Replies: 1
    Last Post: 03-01-2014, 07:10 AM
  5. [SOLVED] How to draw a chart horizontal axis and vertical axis
    By kiany406 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 09-17-2012, 02:56 PM
  6. [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
  7. adding horizontal axis in chart
    By joehardy1 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 10-23-2011, 11:44 AM

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