Locating a Chart

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Peter - 13 Dec 2003 00:44 GMT

This maybe an impossible feat for excel, but I'll ask any
ways. I have 12 charts on one sheet (one for each month of
the year). These charts take up alot of space due to the
complexity of the charts. I would like anyone that is
interested in viewing the charts able to find the Year-To-
Date chart with ease. The charts are as compact as
possible and still able to read (Ctrl and Scroll Button on
Mouse was used).

Is there a way to have a transparent icon or symbol(even
text if possible) to show users in what direction the
chart is?

Reply to this Message

Nigel Graham - 13 Dec 2003 14:43 GMT

If I understand you correctly you are trying to zoom in on a chart?
If that is the case you could use a little VBA to select an area behind the
chart and view selection.
you could add a button to allow a tidy way to use the macro:

zoom_chart ()
Range("I2:Q24").Select 'Selects range Change to fit your spreadsheet
Range("Q24").Activate
ActiveWindow.Zoom = True
Range("M2").Select 'Change to cell behind the chart so they can't see
highlighted cell
End Sub

I hope this does what you wanted.

Nigel Graham

> This maybe an impossible feat for excel, but I'll ask any
> ways. I have 12 charts on one sheet (one for each month of
[quoted text clipped - 8 lines]
> text if possible) to show users in what direction the
> chart is?

Reply to this Message

Peter - 13 Dec 2003 17:28 GMT

I don't know how to do macros.As for zooming on charts, I
kinda wanted to have an arrow point in the direction that
the YTD chart is in. And as I scroll down the arrow keeps
pointing in the direction of the specified chart.

>-----Original Message-----
>If I understand you correctly you are trying to zoom in on a chart?
[quoted text clipped - 28 lines]
>
>.

Reply to this Message

Jon Peltier - 15 Dec 2003 15:52 GMT

Who needs VBA? Put an arrow (or other autoshape) in the workbook, or
just select a cell. Choose Hyperlink from the Insert menu, skip the
first box, and type the range behind the chart in the second box (Named
Location in File). Now clicking on the shape or in the cell will bring
you to the chart.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

> If I understand you correctly you are trying to zoom in on a chart?
> If that is the case you could use a little VBA to select an area behind the
[quoted text clipped - 25 lines]
>>text if possible) to show users in what direction the
>>chart is?

Reply to this Message

Tushar Mehta - 13 Dec 2003 19:20 GMT

For a non-programmatic solution:

Put the YTD chart at the top (or the bottom) and people will always
know where it is. If at the top, then as long as there is a chart
visible above what is currently visible, they need to scroll up.
Reverse if the YTD chart is at the bottom.

Also, consider using just one chart for the monthly information and
change the chart's source based on what is desired. See examples 3
through 6 on the Excel | Tutorials | 'Dynamic Chart' page of my web
site.

Signature

Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

Reply to this Message