# How to specify range of a chart?

#### ianccy

##### Active Member
I have a xy chart, and i want to show only the range (min and max) of the recent 300 data for the Y axis, How to do it? Thanks

### Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.
On 2002-08-29 05:51, ianccy wrote:
I have a xy chart, and i want to show only the range (min and max) of the recent 300 data for the Y axis, How to do it? Thanks

Could you expand a little please,

1) how is your original data set out?
2) what do you mean by of the recent 300 data...? Is there a date field that drives this?
3) what do you mean by Min/Max?
do you simply mean the Max value and the Min value (just 2 points in the chart),
or do you mean the # ammount of Max values and the # amount of Min Values?

Thanks

eg, i have a series of data

X(date) Y
1/1 100
1/2 180
1/3 305
1/4 420
1/5 500
......
8/29 350 (y min=100. max=500)

I would have a chart with x axis (time frame), and y axis (0 to 500).
is it possible to draw only the recent 500 days data each time if i were to continue adding more data. and how to set the Y axis range so that the 500 days data min and max range is drawn. (eg, if the recent 500 days data is from 300 to 500, would show only Y axis 300 to 500)

Replies
1
Views
428
Replies
3
Views
233
Replies
0
Views
180
Replies
3
Views
441
Replies
2
Views
242

1,218,560
Messages
6,143,200
Members
450,469
Latest member
brent3162

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back