Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Graph Question | Excel Discussion (Misc queries) | |||
Graph Question | Excel Discussion (Misc queries) | |||
Graph Question | Excel Discussion (Misc queries) | |||
Bar Graph Question | Excel Discussion (Misc queries) | |||
bar graph question | Excel Discussion (Misc queries) |