Prev: Removing Plot lines between plot points on a line chart
Next: Excel 2003: How to nudge a chart element or shape on a chart?
From: Rob Kattenburg Rob on 26 Jun 2008 12:30
I have a spreadsheet with a line graph on it. I would like to insert this
chart into some sort of floating box that will automatically reposition to
the top of my screen when ever I am roaming around the sheet. ( Would always
like to be able to see the chart when eneting data and have the chart make
the changes necessary).

Is this possible?
rkattenburg(a)rseg.com
From: Andy Pope on 26 Jun 2008 14:01
Hi,

Easiest way is to freeze the top few rows and place the chart in the
frozen area.

Otherwise you will need VBA code in the Selection change event in order
to keep on moving the chart.

Cheers
Andy

Rob Kattenburg wrote:
> I have a spreadsheet with a line graph on it. I would like to insert this
> chart into some sort of floating box that will automatically reposition to
> the top of my screen when ever I am roaming around the sheet. ( Would always
> like to be able to see the chart when eneting data and have the chart make
> the changes necessary).
>
> Is this possible?
> rkattenburg(a)rseg.com

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
From: ShaneDevenshire on 28 Jun 2008 13:14
Hi Rob,

1. You can put the chart on a different sheet than the data, then choose
Window, New Window. Followed by Window Arrange, OK. In one window pick the
other sheet. You should be able to see the chart and the data at the same
time. And you can resize and move the two windows as needed.

2. Or you can keep the chart on the same sheet and do the Window New Window
command followed by Window Arrange. The resize and move the windows around
as desired.
--
cheers,
Shane Devenshire


"Rob Kattenburg" wrote:

> I have a spreadsheet with a line graph on it. I would like to insert this
> chart into some sort of floating box that will automatically reposition to
> the top of my screen when ever I am roaming around the sheet. ( Would always
> like to be able to see the chart when eneting data and have the chart make
> the changes necessary).
>
> Is this possible?
> rkattenburg(a)rseg.com
 | 
Pages: 1
Prev: Removing Plot lines between plot points on a line chart
Next: Excel 2003: How to nudge a chart element or shape on a chart?