I am working on putting together some charts in VBA and could use some assistance with defining properties in the chart.
I'll just list the features I would like to include:
a second data range (Range(X))
two y axis and two x axis
shrink the title font smaller than the default
place the charts one below the other starting in the top left corner of the sheet receiving the charts as output
remove the key describing the lines on the chart
expand the chart area and reduce the frame area similar to the way "sized with window" functions
Any ideas on the properties used to create these?
Code:
With ch .HasTitle = True
.ChartTitle.Text = aa & StartDate & " to " & EndDate
.ChartType = xlLine
.SetSourceData Source:=Range(RngStart & ":" & RngEnd)
' .SetSourceData Source:=Range(X)
End With
I'll just list the features I would like to include:
a second data range (Range(X))
two y axis and two x axis
shrink the title font smaller than the default
place the charts one below the other starting in the top left corner of the sheet receiving the charts as output
remove the key describing the lines on the chart
expand the chart area and reduce the frame area similar to the way "sized with window" functions
Any ideas on the properties used to create these?