Hello,
You can change the chart positioning behavior by: use your curser to click
on the outside edge of the chart (activate it). Then, go to the standard
toolbar and select Format - Selected Chart Area - Properties.
Altenatively, right-click your mouse and select Format Object - Properties.
You can make positioning changes like:
- Move but don't size with cells.
- Don't move or size with cells.
-------
John Mansfield
http://www.cellmatrix.net
"John" wrote:
I'm trying to create my own data table for the x axis of my cluster col
chart. The x axis is the months of the year. I want WSheet col A to align w/
the chart margin, col B to align w/ the Jan chart col, C w/the Feb chart col,
thru col M w/ Dec. How do I do this?
Every time I change the col widith of the excel columns, the chart stretches
or shrinks as the col width does. I can move the graph in the chart to line
up the first col, but then adjusting the size of the graph, moves the chart
around. Nothing seems to work to get all the chart cols to line up w/ the
table cols.
I hope this isn't too confusing. I appreciate your help, -John