+ Reply to Thread
Results 1 to 2 of 2

Macro to update multiple Chart Sheets Y-Axis

  1. #1
    Registered User
    Join Date
    03-03-2017
    Location
    Milwaukee, Wisconsin
    MS-Off Ver
    2013
    Posts
    1

    Macro to update multiple Chart Sheets Y-Axis

    Hi All,

    I'm new to VBA and macros, but from what I understand, they should be able to help me with my issue.

    I've got an excel file that has north of 200 charts that need to get updated monthly. The problem I'm running into is the scaling of the y-axis. I've found that excel's auto function for the axis parameters isn't always what I need. And instead of manually going into each chart and adjusting the axis (which probably would take an entire day), I've been looking for a macro that can do this for me and have been unable to find one thus far.

    Is there a way to have a macro go through each chart in my workbook and find the min data point, and make the y-axis minimum 95% of that point (rounded to the nearest 10,000). Then find the max data point, and may the y-axis maximum 105% of that point (rounded to the nearest 10,000). And have the units be ((y_axis_max-y_axis_min)/10). And finally have this macro run when a button is clicked in the Chart Data Sheet?

    I've attached a sample of the Charts and data that I am using.

    Any help would be greatly appreciated!
    Attached Files Attached Files
    Last edited by zman88; 03-06-2017 at 01:03 PM. Reason: attachment

  2. #2
    Valued Forum Contributor
    Join Date
    09-19-2008
    Location
    It varies ...
    MS-Off Ver
    Office365 - 64bit
    Posts
    862

    Re: Macro to update multiple Chart Sheets Y-Axis

    Try this in your button routine:
    Please Login or Register  to view this content.
    MatrixMan.
    --------------------------------------
    If this - or any - reply helps you, remember to say thanks by clicking on *Add Reputation.
    If your issue is now resolved, remember to mark as solved - click Thread Tools at top right of thread.

+ 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. help with vba code to dynamically update the chart and its axis
    By rv02 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-03-2016, 06:08 AM
  2. Macro to find and update information across multiple sheets and multiple workbooks
    By maxhecht2 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-01-2016, 11:35 AM
  3. [SOLVED] Get a chart to update data with varible X-axis
    By nikolajfh in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-20-2013, 02:04 AM
  4. I need to write a macro or procedure to update multiple sheets
    By martinhardy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-09-2013, 05:29 AM
  5. Replies: 4
    Last Post: 11-26-2012, 01:13 PM
  6. Replies: 5
    Last Post: 11-22-2011, 02:03 PM
  7. Info update between sheets with multiple variables Macro or VLOOKUP Maybe?
    By garretonufer in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-23-2009, 11:29 AM

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