how to zoom into excel line chart with about 2000 point tia sal22
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.
--
If this helps, please click the Yes button.
Cheers,
Shane Devenshire
"Rick T" wrote:
Greetings all
I'm using excel 2003 and have a line chart with over 2000 points how
can I zoom into just a section on the line chart graph? Is this
possible?
tia sal22
|