Change maximum bounds x-y scatter chart excel 2016

#CHANGE MAXIMUM BOUNDS X Y SCATTER CHART EXCEL 2016 CODE#
#CHANGE MAXIMUM BOUNDS X Y SCATTER CHART EXCEL 2016 PASSWORD#

Merge Cells/Rows/Columns without losing Data Split Cells Content Combine Duplicate Rows/Columns.Super Formula Bar (easily edit multiple lines of text and formula) Reading Layout (easily read and edit large numbers of cells) Paste to Filtered Range.

#CHANGE MAXIMUM BOUNDS X Y SCATTER CHART EXCEL 2016 PASSWORD#

Reuse: Quickly insert complex formulas, chartsВ and anything that you have used before Encrypt Cells with password Create Mailing List and send emails.

The Best Office Productivity Tools Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80% Then you will see the minimum value and maximum value of X axis and Y axis all are changed in the selected scatter chart at once. Step 6: Run this VBA with clicking the Run button or pressing the F5 key. Note: F3 is minimum value in X axis, F2 is maximum value in X axis, F4 is the tick value in X axis, G3 is minimum value in Y axis, G2 is maximum value in Y axis, G4 is the tick value in Y axis, and you can change all of them based on your needs. MajorUnit = ActiveSheet.Range('G4').Value MaximumScale = ActiveSheet.Range('G2').Value MinimumScale = ActiveSheet.Range('G3').Value MajorUnit = ActiveSheet.Range('F4').Value MaximumScale = ActiveSheet.Range('F2').Value MinimumScale = ActiveSheet.Range('F3').Value VBA: Change Chart Axis's min/max values by formulas Sub ScaleAxes()

#CHANGE MAXIMUM BOUNDS X Y SCATTER CHART EXCEL 2016 CODE#

Step 5: In the opening Microsoft Visual Basic for Applications window, copy and paste the following code into the window: Step 4: Select the scatter chart, and right click current worksheet name on the Sheet tab bar, and select the View Code from the right-clicking menu. And you can adjust the maximum value or minimum value with changing the numbers in above formulas based on your needs. Note: In above formulas, A2:A18 is the Price column that you figure out x axis scale based on, B2:B18 is the Weight column that you figure out y axis scale based on. (6) Tick value in Y axis: In Cell G4 type 10 or other tick value you need. (5) Minimum value in Y axis: In Cell G3 enter the formula =ROUNDDOWN(MIN(B2:B18)-10,0), and press the Enter key (4) Maximum value in Y axis: In Cell G2 enter the formula =ROUNDUP(MAX(B2:B18)+20,0), and press the Enter key (3) Tick value in X axis: In Cell F4 type 1 or other tick value you need

(2) Minimum value in X axis: In Cell F3 enter the formula =ROUNDDOWN(MIN(A2:A18)-1,0), and press the Enter key. (1) Maximum value in X axis: In Cell F2 enter the formula =ROUNDUP(MAX(A2:A18)+2,0), and press the Enter key

Step 3: Figure out the minimum value and maximum value for X axis and Y axis with formulas: Step 2: Find a blank range besides source data, says Range E1: G4, add titles as below screen shot shown: Step 1: Select your source data, and add a scatter chart with clicking the Insert Scatter (X, Y) and Bubble Chart (or Scatter)> Scatter on the Insert tab. To change chart axis's min/max value with formulas in a scatter chart in Excel, you can do as follows:

Change maximum bounds x-y scatter chart excel 2016