+ Reply to Thread
Results 1 to 4 of 4

How to get chart axis values to set as auto once chart is created

  1. #1
    Forum Contributor
    Join Date
    10-02-2013
    Location
    Houston, TX
    MS-Off Ver
    office 365
    Posts
    638

    How to get chart axis values to set as auto once chart is created

    here is the code that came form recording the macro:
    Please Login or Register  to view this content.
    How to change it to auto when the axis are created

    The date for the chart comes off sheet called "Bottom"
    Last edited by bdouglas1011; 09-03-2014 at 11:24 AM.

  2. #2
    Forum Expert sweep's Avatar
    Join Date
    04-03-2007
    Location
    Great Sankey, Warrington, UK
    MS-Off Ver
    2003 / 2007 / 2010 / 2016 / 365
    Posts
    3,440

    Re: How to get chart axis values to set as auto once chart is created

    Hi,

    You could add something like this to your code

    Please Login or Register  to view this content.
    Rule 1: Never merge cells
    Rule 2: See rule 1

    "Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".

  3. #3
    Forum Contributor
    Join Date
    10-02-2013
    Location
    Houston, TX
    MS-Off Ver
    office 365
    Posts
    638

    Re: How to get chart axis values to set as auto once chart is created

    That worked Ok Could you actually get this one to take the range of the data it pulled it from
    Please Login or Register  to view this content.
    The range comes from Sheet "Bottom" Column 'B' starting at row '2' and continues down till no other rows' Rows always change depending on what date set is used

  4. #4
    Forum Contributor
    Join Date
    10-02-2013
    Location
    Houston, TX
    MS-Off Ver
    office 365
    Posts
    638

    Re: How to get chart axis values to set as auto once chart is created

    Thanks for the above part
    Last edited by bdouglas1011; 09-03-2014 at 09:48 PM. Reason: Posted as new question

+ 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. Replies: 1
    Last Post: 03-01-2014, 07:10 AM
  2. [SOLVED] Dynamic chart title created in VBA does not auto-update
    By DH112213 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-22-2013, 12:38 PM
  3. Replies: 1
    Last Post: 07-12-2012, 02:33 PM
  4. Excel 2007 : Chart Auto Axis Help
    By byujensen in forum Excel General
    Replies: 1
    Last Post: 10-05-2010, 10:39 PM
  5. Chart Axis Scale Auto Values
    By Moses Bunting in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-08-2005, 11:05 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