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
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...