+ Reply to Thread
Results 1 to 2 of 2

Applying Maximum and Minimum Y-axis value to ALL charts on a worksheet

  1. #1
    Registered User
    Join Date
    02-12-2010
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    2

    Applying Maximum and Minimum Y-axis value to ALL charts on a worksheet

    Hi,
    I'm new to VBA but thanks to other experts, I was able to find a macro that lets me produce multiple charts from the same worksheet. However, I need to fix the minimum and maximum values for the y-axis for all of the graphs created using this macro. I can only find how to assign values to a specific chart. I want it done to ALL of them at the same time. Could someone add to this macro below? I need the minimum value to be 0.50 and the max to be 0.75. I also want the major interval to be .05 (and .02 for minor).
    In the "sample" I attached, you will see that Excel automatically changed scaling. It's so misleading.


    Thanks in advance.

    Macro:
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by kkawash; 02-12-2010 at 05:14 PM.

  2. #2
    Registered User
    Join Date
    02-12-2010
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Applying Maximum and Minimum Y-axis value to ALL charts on a worksheet

    Thanks for the tip! Hopefully this is working. I also want to add that each of my charts is made from one row of data (one series) so each row becomes a chart.

    Thanks again.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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