Macro for Graphing Data
 

I am looking for a macro that would allow me to select several columns
of data and create identically sized graphs within excel on the same
sheet. I have tried several options and nothing seems to work. Any
assistance would be great. Thanks

Erica:confused:


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements

Macro for Graphing Data
 

After reading the message, I think that I might need to provide
additional information. What I am looking to do is the following:

I have 3 to 4 columns of data, usually no more than 13 rows worth (i.e.
columns a-d, rows 1-13). This I need a graph that will be based upon
each individual column, so a total of 4 graphs by they must all be
identical in size. Trying to do this manually gets to be a headache.
Because the data can range so drastically, thus throwing the axis size
off. Is there a way that I can do this?


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements

Macro for Graphing Data
 

Jon Peltier has a sample file that may help you:


http://www.geocities.com/jonpeltier/...tCreation.html


Newdlj wrote:
After reading the message, I think that I might need to provide
additional information. What I am looking to do is the following:

I have 3 to 4 columns of data, usually no more than 13 rows worth (i.e.
columns a-d, rows 1-13). This I need a graph that will be based upon
each individual column, so a total of 4 graphs by they must all be
identical in size. Trying to do this manually gets to be a headache.
Because the data can range so drastically, thus throwing the axis size
off. Is there a way that I can do this?

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Macro for Graphing Data
 

Here's a sample macro to get you started. Select a range and it will
work on that range; select a cell and it will work on the entire current
region of the range, the contiguous range containing data. It makes one
chart for each column in the range, and puts each chart lower than the
last so they don't all overlap.

Sub MakeCharts()
Dim myRange As Range
Dim myChartOb As ChartObject
Dim iColCt As Integer
Dim iColIx As Integer
Dim ht As Integer
Dim wd As Integer

ht = 200 ' Chart height
wd = 275 ' Chart width
If TypeName(Selection) = "Range" Then
If Selection.Cells.Count = 1 Then
Set myRange = Selection.CurrentRegion
Else
Set myRange = Selection
End If
iColCt = myRange.Columns.Count
For iColIx = 1 To iColCt
Set myChartOb = ActiveSheet.ChartObjects.Add _
(myRange.Left + myRange.Width, _
myRange.Top + (iColIx - 1) * ht, wd, ht)
With myChartOb.Chart
.SetSourceData myRange.Columns(iColIx)
' include other embellishments he
' titles, chart type, series formatting
' fonts, colors, etc.
End With
Next
Else
MsgBox "Select a cell in your target range and try again."
End If
End Sub

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______


Newdlj wrote:

After reading the message, I think that I might need to provide
additional information. What I am looking to do is the following:

I have 3 to 4 columns of data, usually no more than 13 rows worth (i.e.
columns a-d, rows 1-13). This I need a graph that will be based upon
each individual column, so a total of 4 graphs by they must all be
identical in size. Trying to do this manually gets to be a headache.
Because the data can range so drastically, thus throwing the axis size
off. Is there a way that I can do this?