(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:
0 kommentar(er)
