Prev: Chart with differing x axis
Next: Get 2007 Chart to fill page
From: paweston on 18 May 2010 09:54
I am interested in selecting a section of my chart to zoom in on. I would
like to identify the x-axis range from the plot/graph and have a new
plot/graph generated showing the zoomed in area. I can do this by going back
to the worksheet and hiding all the data except what I am interested in
seeing...but this is time consuming.
From: Luke M on 18 May 2010 11:22
Jon Peltier has done some work on this, you might check out:
http://peltiertech.com/Excel/ExampleSolutions.html

Or, you could possibly just create a dynamic chart, and use a scroll
wheel/slider bar to control the x-axis
http://peltiertech.com/Excel/Charts/Dynamics.html

--
Best Regards,

Luke M
"paweston" <paweston(a)discussions.microsoft.com> wrote in message
news:2A1847E4-C381-47DE-BDEF-82B29912901E(a)microsoft.com...
>I am interested in selecting a section of my chart to zoom in on. I would
> like to identify the x-axis range from the plot/graph and have a new
> plot/graph generated showing the zoomed in area. I can do this by going
> back
> to the worksheet and hiding all the data except what I am interested in
> seeing...but this is time consuming.


 | 
Pages: 1
Prev: Chart with differing x axis
Next: Get 2007 Chart to fill page