Question on Graph XLGraphType
 

I've built the following function to create graphs (based on other
functions I've seen online):

Public Function AddChartObject(objWs As Worksheet, intLeft As Integer, _
intTop As Integer, intWidth As Integer, intHeight As Integer, _
xlChartType As xlChartType) As ChartObject
Dim objChart As ChartObject
Set objChart = objWs.ChartObjects.Add(Left:=intLeft,
Width:=intWidth, Top:=intTop, Height:=intHeight)
objChart.Chart.ChartType = xlChartType
Set AddChartObject = objChart
End Function

Which I'm calling like such:
Set objChart = AddChartObject(objWs, 20, 156, 400, 252, xl3DBarStacked)

In the latter 'xl3DBarStacked' is the XLGraphType which gives me
horizontal bars in the graph. But what if I want vertical bars, what's
the constant for that.

Also, if I browse the list of XLGraphType's in the object browser, how
do I work out what kind of graph is generated without individually
trying out each constant in my AddChartObject function?

Thanks,
Wayne C.

Question on Graph XLGraphType
 

The vertical bars are called "columns" in Excel. You probably don't need to
try all of the constants, just try out the ones you don't recognize, and
fill in the rest. It shouldn't take to long to run a few tests.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Wayne Cressman" wrote in message
t...
I've built the following function to create graphs (based on other
functions I've seen online):

Public Function AddChartObject(objWs As Worksheet, intLeft As Integer, _
intTop As Integer, intWidth As Integer, intHeight As Integer, _
xlChartType As xlChartType) As ChartObject
Dim objChart As ChartObject
Set objChart = objWs.ChartObjects.Add(Left:=intLeft, Width:=intWidth,
Top:=intTop, Height:=intHeight)
objChart.Chart.ChartType = xlChartType
Set AddChartObject = objChart
End Function

Which I'm calling like such:
Set objChart = AddChartObject(objWs, 20, 156, 400, 252, xl3DBarStacked)

In the latter 'xl3DBarStacked' is the XLGraphType which gives me
horizontal bars in the graph. But what if I want vertical bars, what's
the constant for that.

Also, if I browse the list of XLGraphType's in the object browser, how do
I work out what kind of graph is generated without individually trying out
each constant in my AddChartObject function?

Thanks,
Wayne C.