Thanks, the Chart in a Cell looks like a good approach, but I already have a
workbook and I already have 10 charts ... is there an easy way to cut and
paste the charts into cells in my existing workbook and have the chart
borders locked to the cell borders.

cheers, BDT

"Kelly O'Day" wrote in message
...
I have found two ways to align multiple charts on a worksheet. Method 1 is
to size and align floating charts with a VBA procedure.

The second way is to place my charts in single cells. the row height and
column width set the chart size and they are automatically aligned with
row and column boundaries.

If you want your charts to float, the following code will get you started.

Public Sub Size_align_charts()
Dim ChtWidth As Long, ChtHeight As Long
Dim TopPosition As Long, LeftPosition As Long
Dim chtobj As ChartObject

If ActiveChart Is Nothing Then Exit Sub
'Get size of active chart
ChtWidth = ActiveChart.Parent.Width
ChtHeight = ActiveChart.Parent.Height
TopPosition = ActiveChart.Parent.Top
LeftPosition = ActiveChart.Parent.Left
For Each chtobj In ActiveSheet.ChartObjects
chtobj.Width = ChtWidth
chtobj.Height = ChtHeight
chtobj.Top = TopPosition
chtobj.Left = LeftPosition
TopPosition = TopPosition + chtobj.Height
Next chtobj
End Sub

See my website for information on how to place charts in cells.

http://processtrends.com/TOC_charts.htm

..Kelly



"BT" wrote in message
...
I'm having a lot of trouble arranging multiple charts on a page.
Actually I'm doing 10 charts that are all the same size on 2 pages with 6
on the first page, then 4 on the last. I'm having a heck of time trying
to get this right. I select all 10 charts and stretch them this way and
that and adjust some row and column widths between the charts to make
adjustments, but I can't get it right. There has to be a better method
that this trial and error approach.

I've search the web, but almost everything I've found is for some fancy
charting program to do this. It must be doable within Excel. Can anyone
give me some pointers or, better yet, give me a link to some sort of
advanced Excel charting tutorial that could help.

many thanks, BDT