xlcategory

I have the following code that returns an error, "Method 'MaximumScale' of object 'Axis' failed", on the line in red: With ActiveSheet.ChartObjects("Chart 3").Chart dblXScale = (.Axes(xlCategory).MaximumScale - .Axes(xlCategory).MinimumScale) / LArea.Width dblYScale =...

Hi! I try to make a function that draws a line chart for me, but I ran into some difficulties. I have three columns on a sheet. The first one is time, formatted as hh:mm:ss. I want these on the x axis. The second and third columns are my values, in this case temperatures. The y axis is...

First time post - please be gentle. I have responsibility for a VB6 program (and Excel 2007) that creates an excel stacked column chart that shows defects for a mile range. The mile range can be continuous oe noncontinuous and can have odd mile post numbers (like 6.28) out of the blue. The...

I can change the color, size, etc. of the axes colors manually - can this be done via VBA? I see how to set the value where it crosses, tick marks, etc. I am using Excel 2007 Thank you.