# 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

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

#### Ian Mac

##### MrExcel MVP
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

#### ianccy

##### Active Member
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
6
Views
211
Replies
1
Views
90
Replies
0
Views
216
Replies
5
Views
573
Replies
6
Views
165

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,152,110
Messages
5,768,156
Members
425,458
Latest member
Jaspal1996

### 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