+ Reply to Thread
Results 1 to 3 of 3

How to edit Axes(xlCategory) labels in VBA Excel 2016?

  1. #1
    Forum Contributor
    Join Date
    04-22-2014
    Location
    Turrialba, Costa Rica
    MS-Off Ver
    Excel 2010
    Posts
    108

    Unhappy How to edit Axes(xlCategory) labels in VBA Excel 2016?

    Hello.
    I have a xlColumnStacked Chart and I urgently need to edit the Axes(xlCategory) labels.
    I already recorded this macro:´
    Please Login or Register  to view this content.
    But running the macro, VBA displays this run-time error -2147467259 (80004005): Invalid parameter.
    I am really confused and unable to find a solution in the web.
    I rally appreciate any help.

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

    Re: How to edit Axes(xlCategory) labels in VBA Excel 2016?

    Macro recorder is not always helpful.

    Please Login or Register  to view this content.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Forum Contributor
    Join Date
    04-22-2014
    Location
    Turrialba, Costa Rica
    MS-Off Ver
    Excel 2010
    Posts
    108

    Re: How to edit Axes(xlCategory) labels in VBA Excel 2016?

    Andy.
    Now my Chart looks great.
    Thank you very much indeed

+ 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. 3D maps excel 2016 add data labels
    By Gadget_Buster in forum Excel General
    Replies: 2
    Last Post: 06-24-2019, 04:56 AM
  2. Format Data Labels Vertically using Pareto in Excel 2016
    By 1gambit in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 10-03-2017, 01:39 PM
  3. Excel 2016 edit icon
    By tcebob in forum Excel General
    Replies: 3
    Last Post: 07-01-2016, 03:58 AM
  4. Move the x-axis (axes(xlCategory) up. Can this be done?
    By russurquhart1 in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 07-22-2012, 01:16 PM
  5. .Axes(xlCategory) causing error 438 changing Scale
    By JackRnl in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-28-2010, 04:35 AM
  6. Axes(xlCategory).MinimumScale in 2007
    By yellowlion in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-13-2009, 12:05 PM
  7. [SOLVED] Axes(xlCategory).TickLabels problem
    By deko in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-05-2005, 11:07 PM

Tags for this Thread

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