Hi,
Let's suppose you have data laid out like this
X-axis Data
AAA 3
ABA 2
DCD 4
BBB 1
....
add a column to the left or right of your data with any title, lets say
Filter. Enter 1 below the titles and 2 on the 3rd line. Highlight the 1 and
2 and drag the fill handle down.
Apply a filter to your range - Data, Filter, AutoFilter
Open the filter on the new column and choose Custom, from the first dropdown
choose is greater than or equal to and enter the lower value of the range you
want to zoom in on, in the second drop down pick is less than or equal to and
enter the upper limit you want to see.
By default charts display only visible cells.
You may not need a dummy column depending on whether your data is already
sorted.