Is there a way to make a graph in Excel "float" on top of the sheet that it
is in, so that I can scroll across the data, and still see all of the graph.
Thanks,
Rob Lepper
Dave Peterson - 06 Dec 2006 14:44 GMT
How about an easy alternative?
Create another window (window|New Window)
then arrange them so that you can see the things you want to see
(Window|arrange|horizontal or vertical).
You'll see book1.xls:1 and book1.xls:2 in the window title bar. When you're
done and want to go back to "normal", you can select the window you want to
close and hit ctrl-w.
> Is there a way to make a graph in Excel "float" on top of the sheet that it
> is in, so that I can scroll across the data, and still see all of the graph.
>
> Thanks,
>
> Rob Lepper

Signature
Dave Peterson
OM - 07 Dec 2006 11:49 GMT
Thnak you Dave - of all the alternatives, this gives me the result I want
best. What I want to be able to do is enter production figures in a table,
and see if the maximum daily production is exceeded, when a range of
products are made. Your method allows the graph to be any size I want, and
to move anywhere in the data (in the window below) without changing the
table's position.
I'm sure this could also be done with VBA (to automate your method), so I'll
give that a go....
Thanks again,
Rob
> How about an easy alternative?
>
[quoted text clipped - 16 lines]
>>
>> Rob Lepper
Earl Kiosterud - 06 Dec 2006 16:40 GMT
Rob,
You can put it in the frozen part of the sheet when using Window - Freeze
Panes.

Signature
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
> Is there a way to make a graph in Excel "float" on top of the sheet that
> it is in, so that I can scroll across the data, and still see all of the
[quoted text clipped - 3 lines]
>
> Rob Lepper
Bruce Sinclair - 06 Dec 2006 23:43 GMT
>Is there a way to make a graph in Excel "float" on top of the sheet that it
>is in, so that I can scroll across the data, and still see all of the graph.
Try right click/format chart area/don't move or size with cells.
Very handy for looking at various columns of data a few at a time.
Miyahn - 07 Dec 2006 03:23 GMT
> Is there a way to make a graph in Excel "float" on top of the sheet that it
> is in, so that I can scroll across the data, and still see all of the graph.
If you don't mind using VBA, see this thread and modify the code for charts.
"Floating Command button"
http://groups.google.com/group/microsoft.public.excel/browse_frm/thread/19dca08e
629fe707

Signature
Miyahn
Microsoft MVP for Microsoft Office - Excel(Jan 2006 - Dec 2006)
https://mvp.support.microsoft.com/profile=e971f039-a892-426c-9544-83d372c269b4