+ Reply to Thread
Results 1 to 3 of 3

Set maximum y or x axis values using VBA spinbutton

  1. 09-10-2019, 07:22 AM #1
    moamen_2019
    moamen_2019 is offline
    Registered User
    Join Date
    09-05-2019
    Location
    Egypt
    MS-Off Ver
    Office Professional Plus 2013
    Posts
    9

    Set maximum y or x axis values using VBA spinbutton

    I have a chart that I want to change its maximum y axis value using a spin button on my worksheet.
    Can anyone helps me in that ?

    I am attaching the workbook I am working on.
    I want to use spin button 5 to change maximum y axis in the chart above it.

    Mo'men
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 09-10-2019, 09:26 AM #2
    KOKOSEK
    KOKOSEK is offline
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    2,742

    Re: Set maximum y or x axis values using VBA spinbutton

    I've connect Spinbutton5 into cell AP25 (covered but spinbutton5) and then into sheet code:

    Please Login or Register  to view this content.
    Happy with my answer * Add Reputation.
    If You are happy with solution, please use Thread tools and mark thread as SOLVED.
    Reply With QuoteRegister To Reply
  3. 09-12-2019, 07:19 AM #3
    moamen_2019
    moamen_2019 is offline
    Registered User
    Join Date
    09-05-2019
    Location
    Egypt
    MS-Off Ver
    Office Professional Plus 2013
    Posts
    9

    Re: Set maximum y or x axis values using VBA spinbutton

    Thanks KOKOSEK
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Changing Y-Axis of Excel chart to capture minimum and maximum values through a formula
    By psv2006 in forum Excel General
    Replies: 1
    Last Post: 06-21-2016, 12:26 AM
  2. Variable minimum and maximum axis values?
    By HalPlz in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 10-09-2015, 02:13 AM
  3. Reverse Ordered Y-Axis with X-axis crossing at maximum value of a 100% Stacked Area Chart
    By erenz88 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 07-09-2015, 06:21 AM
  4. VBA to set Minimum and Maximum Values of X Axis
    By astha.malik1 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-18-2014, 04:42 AM
  5. linking maximum and minimum y axis values to a cell value
    By randor in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-15-2013, 08:12 PM
  6. Logarithmic graph scaling changes when changing minimum or maximum values for x axis
    By excelZen in forum Excel Charting & Pivots
    Replies: 10
    Last Post: 10-07-2013, 11:41 AM
  7. How to set the maximum label of the y-axis to the maximum value of a line
    By zjianguk in forum Excel General
    Replies: 1
    Last Post: 11-04-2012, 10:27 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1