Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
how to zoom into excel line chart with about 2000 point tia sal22
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 |
#2
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to zoom into excel line chart with about 2000 point tia sal22
If you only want to show a section of the chart you can double click on the x axis at the bottom click the scale tab and choose the minimum and maximum values you need to look at. This will only show the section of the graph between these two values. "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 |
#3
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to zoom into excel line chart with about 2000 point tia sal22 | Excel Discussion (Misc queries) | |||
how to zoom into excel line chart with about 2000 point tia sal22 | Excel Worksheet Functions | |||
Line and Point in the same chart? | Charts and Charting in Excel | |||
Pasting line to a chart point | Excel Programming | |||
How do I get a value of a calculated point on an excel line chart? | Charts and Charting in Excel |