B
Bill
I'm running Excel 2007 Home and Student and have 4 columns of data with a pie
chart located to the right of the 4 columns. The pie chart is comprised of
the data from 2 of the columns which calculate a total at the very bottom of
the spreadsheet. What I am trying to find out is if I insert the chart at
the top of my spreadsheet, how can I get the chart to move down the
spreadsheet as I scroll down through my data, or in fact, using Freeze pane
for the top Row headings to remain visible, I'd like the chart to stay right
up near the top at all times and remain visible when I scroll down. Is this
possible? The more that I think about this, it's almost like I'm asking the
chart to move down the spreadsheet as I scroll down, and/or move back up as I
scroll up the sheet. The sheet is not wide enough to have to scroll left and
right, just up and down.
Any help will be appreciated!
chart located to the right of the 4 columns. The pie chart is comprised of
the data from 2 of the columns which calculate a total at the very bottom of
the spreadsheet. What I am trying to find out is if I insert the chart at
the top of my spreadsheet, how can I get the chart to move down the
spreadsheet as I scroll down through my data, or in fact, using Freeze pane
for the top Row headings to remain visible, I'd like the chart to stay right
up near the top at all times and remain visible when I scroll down. Is this
possible? The more that I think about this, it's almost like I'm asking the
chart to move down the spreadsheet as I scroll down, and/or move back up as I
scroll up the sheet. The sheet is not wide enough to have to scroll left and
right, just up and down.
Any help will be appreciated!