split axis

Shabby · May 2nd, 2002, 01:15 PM

How can I split the Y axis to skip over contiuous data and just show the top and bottom values?
Thanks

Wayne Duncan · May 2nd, 2002, 01:30 PM

The only way I know is to click "Window", select "New Window", select "Arrange", select "Horizontal". Now youve got 2 views of the same sheet.
Then do "Windows", "Freeze Panes" in the top file to freeze the top section and use the bottom file see the bottom. Work in the top file. Crufty I know.

You can't "freeze panes" and "split" at the same time unfortunately.

Shabby · May 2nd, 2002, 01:40 PM

I don't think my last question was clear. I am wondering how to split the axis on a chart in excel. I am trying to graph the max, min and average , but the max and min are so far apart that you can't see the average.
Thanks

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 2nd, 2002, 01:15 PM	#1
Shabby New Member Join Date: May 2002 Posts: 2	How can I split the Y axis to skip over contiuous data and just show the top and bottom values? Thanks

May 2nd, 2002, 01:30 PM	#2
Wayne Duncan Board Regular Join Date: Apr 2002 Location: Toronto Posts: 73	The only way I know is to click "Window", select "New Window", select "Arrange", select "Horizontal". Now youve got 2 views of the same sheet. Then do "Windows", "Freeze Panes" in the top file to freeze the top section and use the bottom file see the bottom. Work in the top file. Crufty I know. You can't "freeze panes" and "split" at the same time unfortunately.

May 2nd, 2002, 01:40 PM	#3
Shabby New Member Join Date: May 2002 Posts: 2	I don't think my last question was clear. I am wondering how to split the axis on a chart in excel. I am trying to graph the max, min and average , but the max and min are so far apart that you can't see the average. Thanks