Dynamic Axis in chart

Hi, I want a dynamic axis chart in excel that when I input a number, it automatically change the axis (base on my input). I ask these before and someone give this file to me but it have a macros and I want to do it without any macros.
Is there any solution for this?
Thanks for your attention and sorry for my bad English.

I have a technique for this that doesn't require VBA. Just for clarity, by "dynamic axis based on input" do you mean an axis that changes according to an input cell?

Create Named Ranges as OFFSET functions. You'll need to create two named ranges, one for your Excavation axis, the other for your "no" axis.

Press Ctrl+F3 (Opens named range manager)

Click "New"

Enter a Name (no/excavation)

For "Refers to:" enter the below formulas -

For the "no" Axis: =OFFSET($A$1,1,0,$I$2,1)
For the "Excavation" Axis: OFFSET($B$1,1,0,$I$2,1)

Now, assign these functions to your graph.

Right-click on your graph and choose "Select Data"

Edit the "Legend Entries" item. For the "Series Values:" section, click on the box that allows you to select an area in the sheet. Then click anywhere in your sheet. Delete the characters until just the sheet reference remains, it will read "='2'!" then press F3. Select the "excavation" name you created above. Click OK.

Repeat the above step but for the "Horizontal Axis" and select the "no" name created previously. Click OK.

You will now be able to change the scope of your graph by changing the value of cell("I2").

thanks somuch. it works Great!!