Page 2 of 2 FirstFirst 12
Results 11 to 15 of 15

Thread: Chart Zoomer (Resizer)

  1. #11
    Senior Member
    Join Date
    Apr 2011
    Posts
    190
    Rep Power
    14
    Last edited by DocAElstein; 10-24-2023 at 03:01 PM.
    xl2007 - Windows 7
    xl hates the 255 number

  2. #12
    Administrator Admin's Avatar
    Join Date
    Mar 2011
    Posts
    1,123
    Rep Power
    10
    Hi Rasm,

    Sorry for the late reply. Forum was down for the last 24 hours

    Replace

    Code:
    If objChartObject.Chart.ChartArea.Interior.Color = -2 Then
            objChartObject.Chart.ChartArea.Interior.Color = ZoomInChartAreaColor
        End If
    with

    Code:
    If objChartObject.Chart.ChartArea.Format.Fill.ForeColor.RGB = ZoomInChartAreaColor Then
            objChartObject.Chart.ChartArea.Format.Fill.ForeColor.RGB = ZoomInChartAreaColor
        End If
    Essentially replace
    Code:
    objChartObject.Chart.ChartArea.Interior.Color
    with

    Code:
    objChartObject.Chart.ChartArea.Format.Fill.ForeColor.RGB
    HTH

  3. #13
    Junior Member
    Join Date
    Oct 2011
    Posts
    1
    Rep Power
    0
    This Chart Zoomer is exactly what I needed for a dashboard I'm working on. I did notice that after using this a few times I am unable to scroll down or right...Any idea how to fix this?

    Thanks again for this chart zoomer. you have no idea how helpful this is!

    Thanks,

    A

  4. #14
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,402
    Rep Power
    10
    Search for the line
    Code:
    .Parent.ScrollArea = strVsblRngAddr
    and comment it/remove it.
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

  5. #15
    Junior Member
    Join Date
    Dec 2020
    Posts
    1
    Rep Power
    0
    I did not realise this is actually just a chart blow up, it does not allow to zoom in a portion of the chart.
    I cannot have any Excel add-ins installed due to network security at the workplace (understandable...) and I must develop a chart tool where it is possible to highlight any section of a chart and "zoom" into this section, which means:

    1. Identifying any series currently on the chart
    2. identifying the x-axis date/time values boundaries highlighted from the zoom area on the chart
    3. filtering the pivot table accordingly (I am working with pivot tables > pivot chart from a recordset extracted via ODBC VBA connection)

    I have difficulties finding such information on Google.

    This tool is definitely a very nice tiny chart expansion tool

    Any suggestion would be greatly appreciated.
    Thank you

Similar Threads

  1. Drag And Zoom Chart Zoomer Add-In
    By Jason Vint in forum Download Center
    Replies: 3
    Last Post: 08-02-2013, 02:30 PM
  2. Excel Chart Showing Values on Angle: Nightingale Chart
    By Rajan_Verma in forum Rajan Verma's Corner
    Replies: 0
    Last Post: 10-17-2012, 06:39 PM
  3. Replies: 1
    Last Post: 05-20-2012, 12:23 PM
  4. Chart zoomer by Kris
    By Rasm in forum Excel Help
    Replies: 2
    Last Post: 07-06-2011, 10:24 PM
  5. Krishnarkumar's Chart Zoomer
    By Jim Fleming in forum Excel Help
    Replies: 0
    Last Post: 04-03-2011, 09:04 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •