Zoom Or Expand Line Chart X-axis

  • 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,

  • 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.

    [SIZE=1]Entia non sunt multiplicanda sine necessitate.[/SIZE]

  • 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

    Regards,


    Wigi


    Excel MVP 2011-2014


    For more Excel memes: visit http://www.wimgielis.com ==> English articles ==> Excel memes


    -- Topics without [CODE] tags or a meaningful topic title, will be neglected by me (and probably many others as well) --