Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Robin McInnes
 
Posts: n/a
Default Permanently visible colunm in an Excel chart

Hi, could someone please tell me how to 'lock' a column in an excel
chart? I am using Office XP (2002) on Windows XP Pro SP2.

I downloaded a template from Microsoft called 'Landscape Plant List',
which is basically a list of plants, along with their needs &
characteristics. The name of the plant is in column B, and then multiple
columns to the right of that contain various bits of information about
the plant specified in that column.

The chart is wider than the screen, so one has to scroll across to see
the columns on the far right, and when I scroll across the chart _Column
B, with the plant name in it remains stationary_, and thus is visible,
all the time.

I'd like to design some excel charts of my own with a similar 'locked
main-title column' but wherever I've tried looking in cell or column
properties etc, I can't seem to spot what it is they've done on the
downloaded template to make it behave like that.

--
Cheers,
Robin McInnes

Cheshire, UK

(Email address in header contains a spam trap. Remove it to email me.)
  #2   Report Post  
Sunil Jayakumar
 
Posts: n/a
Default

Hi Robin,
Select on the intersect you want to "lock" i.e. if you only want to lock
Column A, highlight Col B and go to WindowFreeze Panes.

If you want to lock the row headers as well - select cell B2 and go to
WindowFreeze Panes.

You could also use Window Split in a simlar way, and this will allow you
to navigate within each of the frames as well.

Hope this helps

Sunil Jayakumar


"Robin McInnes" wrote in message
...
Hi, could someone please tell me how to 'lock' a column in an excel chart?
I am using Office XP (2002) on Windows XP Pro SP2.

I downloaded a template from Microsoft called 'Landscape Plant List',
which is basically a list of plants, along with their needs &
characteristics. The name of the plant is in column B, and then multiple
columns to the right of that contain various bits of information about the
plant specified in that column.

The chart is wider than the screen, so one has to scroll across to see the
columns on the far right, and when I scroll across the chart _Column B,
with the plant name in it remains stationary_, and thus is visible, all
the time.

I'd like to design some excel charts of my own with a similar 'locked
main-title column' but wherever I've tried looking in cell or column
properties etc, I can't seem to spot what it is they've done on the
downloaded template to make it behave like that.

--
Cheers,
Robin McInnes

Cheshire, UK

(Email address in header contains a spam trap. Remove it to email me.)


www.ayyoo.com/credit-cards.html


  #3   Report Post  
Brian Ferris
 
Posts: n/a
Default

Good afternoon mate ...

All it takes is ... highlight Column C and go to "Window"
menu and choose Freeze panes, whilst still having column C
highlighted ,if u want to remove just choose unfreeze
panes from same window menu ...

Good day to you !
Brian

-----Original Message-----
Hi, could someone please tell me how to 'lock' a column

in an excel
chart? I am using Office XP (2002) on Windows XP Pro SP2.

I downloaded a template from Microsoft called 'Landscape

Plant List',
which is basically a list of plants, along with their

needs &
characteristics. The name of the plant is in column B,

and then multiple
columns to the right of that contain various bits of

information about
the plant specified in that column.

The chart is wider than the screen, so one has to scroll

across to see
the columns on the far right, and when I scroll across

the chart _Column
B, with the plant name in it remains stationary_, and

thus is visible,
all the time.

I'd like to design some excel charts of my own with a

similar 'locked
main-title column' but wherever I've tried looking in

cell or column
properties etc, I can't seem to spot what it is they've

done on the
downloaded template to make it behave like that.

--
Cheers,
Robin McInnes

Cheshire, UK

(Email address in header contains a spam trap. Remove it

to email me.)
.

  #4   Report Post  
Robin McInnes
 
Posts: n/a
Default

Brian & Sunil, that was exactly what I needed to know. Thank you both
very much indeed.

--
Cheers,
Robin McInnes

Cheshire, UK

(Email address in header contains a spam trap. Remove it to email me.)
  #5   Report Post  
Sunil Jayakumar
 
Posts: n/a
Default

Hi Robin,

Thanks for the feedback - happy to help.

Cheers

Sunil Jayakumar

"Robin McInnes" wrote in message
...
Brian & Sunil, that was exactly what I needed to know. Thank you both very
much indeed.

--
Cheers,
Robin McInnes

Cheshire, UK

(Email address in header contains a spam trap. Remove it to email me.)


www.ayyoo.com/loans.html


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Find and replace data in an Excel chart object Cawen Charts and Charting in Excel 2 March 31st 05 06:47 PM
Excel chart like the FTSE chart Charts and Charting in Excel 0 February 9th 05 03:26 PM
Missing values in Excel Line Chart mw55309 Charts and Charting in Excel 1 January 19th 05 01:10 PM
BUG?: Excel scatter chart: will not plot x-values Bob Excel Discussion (Misc queries) 2 December 31st 04 01:19 AM
Is there a way to create a standard OHLC bar chart in Excel? [email protected] Charts and Charting in Excel 3 December 2nd 04 10:49 PM


All times are GMT +1. The time now is 11:35 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"