Zoom Or Expand Line Chart X-axis

darthrader · Jun 17th 2007

I have an Excel chart as a separate worksheet. It has 10,000 data points. Is there a way to Zoom in on the X-axis only. I am looking to expand or zoom the X-axis to take a closer look at the individual data points. Since I have 10,000, I need a way to take a closer look at an area defined by the mouse pointer.

Can this be done with VB code? I am not looking to expand or zoom the "Y" axis, this can be done with the scale values. Can this be done with a mouse drag or double click on the area of the chart I want to expand.

Thanks in advance,

shg · Jun 17th 2007

Re: Zoom Or Expand Line Chart X-axis

You can use dynamic named ranges (numerous examples here on Oz) for the category and value axes. The ranges would recalculate based on two cells that specify the offset (start position) and number of entries (zoom) to be displayed. Those cells could in turn be controlled by sliders from the Forms or Controls toolbar.

Wigi · Jun 17th 2007

Re: Zoom Or Expand Line Chart X-axis

Hi

Have a look here, in particular, the zip file AutoChrt.zip.

For more information on dynamic ranges, see here: http://www.ozgrid.com/Excel/DynamicRanges.htm

Wigi

darthrader · Jun 19th 2007

Re: Zoom Or Expand Line Chart X-axis

I do not know much about dynamic ranges, and I will look into this later this week.

Thanks for the feedback.

Zoom Or Expand Line Chart X-axis

Participate now!

Share