How to specify range of a chart?

ianccy

Active Member
Joined
Jul 28, 2002
Messages
332
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

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

Ian Mac

MrExcel MVP
Joined
Feb 20, 2002
Messages
1,174
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
Joined
Jul 28, 2002
Messages
332
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)
 

Forum statistics

Threads
1,147,508
Messages
5,741,570
Members
423,668
Latest member
Audorin

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top