Charts

hg363 — Wed, 24 Jun 2009 20:10:11 GMT

Hi I found a very interesting post on here that made reference to the following

chart.Plotarea.Interior.Color = RGB(40,80,120)
chart.Title.Font.Size=16
chart.Title.Font.Name="Trebuchet MS"
chart.GapDepth = 30
chart.GapWidth = 30
chart.ChartDepth = 75
chart.Rotation = 40
chart.Inclination = 0
chart.LightNormal = 0.8
chart.AmbientLightIntensity = 0.7
chart.DirectionalLightRotation = 15

But could some one please show me (may be by example) how the above would be incorporated with the code I am using below (Sorry but all this is some what new to me) Thank you Mr Ghelani (UK)

Set objinputFormat = CreateObject("MSUtil.LogQuery.CSVInputFormat")Set objOutputFormat = CreateObject("MSUtil.LogQuery.ChartOutputFormat")objOutputFormat.chartType = "BarStacked"

Input Formats

Charts