Column Widths
 

how do I change column width smaller on one bit of chart but keep what is
above the same as before, i.e. I have 2 large colums above but want abot 5
columns underneath but still taking up same space. I am constructing a chart
that requires different sizes of rows and columns within the one document.

Column Widths
 

Hi,

The only way is to merge the cells above the chart, probably better to have
6 small columns then merge the two '3's above. #You may have to do this
manually but you can just do the top one, row 1 then double-click the format
painter and use the cursor keys to move down quickly merging as it goes

"Kooky" wrote:

how do I change column width smaller on one bit of chart but keep what is
above the same as before, i.e. I have 2 large colums above but want abot 5
columns underneath but still taking up same space. I am constructing a chart
that requires different sizes of rows and columns within the one document.

Column Widths
 

Hi Kooky,

There is another option.
In a blank sheet put something like 'test' in say cell F4
then select F4 to J4, right click and goto Format CellsAlignment Tab
and under the Horizontal pull-down select 'Centre Across Selection'

You will see that the visual effect is the same as merge cells, but the
cells
still retain their integrity so a selection range that runs through that
part of the worksheet will not be compromised.

HTH
Martin



"Kooky" wrote in message
...
how do I change column width smaller on one bit of chart but keep what is
above the same as before, i.e. I have 2 large colums above but want abot 5
columns underneath but still taking up same space. I am constructing a
chart
that requires different sizes of rows and columns within the one document.