Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Logarithmic Chart in VBA
I would like to know how to set Axis in Graph.Chart, so it will draw a
Logarithmic Chart instead of linear one. Thx ----------------------------------- Dim ppoChart As PowerPoint.Shape Dim mgoChart As Graph Set ppsCurrent = ppppDOB.Slides.Add((ppppDOB.Slides.Count + 1), ppLayoutTitleOnly) Set rstInfo = GetChartInfo(plngDataID) Set rstData = GetChartData(rstInfo("cmnDoDAACID"), rstInfo("cmnFuelTypeID"), rstInfo("cmnDFSPTypeAvgSpan"), rstInfo("dobDataAsOfDate")) If Not rstData.EOF Then Set ppoChart = ppsCurrent.Shapes.AddOLEObject(15, 125, 700, 400, "MSGraph.Chart") Set mgoChart = ppoChart.OLEFormat.Object mgoChart.ChartType = xlLine ' draw line chart mgoChart.Axes(xlCategory).CategoryType = xlCategoryScale 'mgoChart.Axes(xlValue). ' ??? how to set axis ??? Thx --- Message posted from http://www.ExcelForum.com/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Logarithmic Chart in VBA
Right click on the axis to change to log scale and choose
Format Axis. On the Scale Tab, click the Logarithmic Scale box. HTH Kevin Sprinkel -----Original Message----- I would like to know how to set Axis in Graph.Chart, so it will draw a Logarithmic Chart instead of linear one. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Logarithmic Chart in VBA
Found it:
"mgoChart.Axes(xlValue).ScaleType = xlScaleLogarithmic" is the call. --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - why use a logarithmic scale in a chart? | Charts and Charting in Excel | |||
How do you create a logarithmic chart? | Charts and Charting in Excel | |||
How do I add another cycle to a logarithmic chart? | Charts and Charting in Excel | |||
How do I plot chart with negative value using Logarithmic Scale ? | Charts and Charting in Excel | |||
how can I make a chart with the x-axis in logarithmic scale | Charts and Charting in Excel |