Fine Tuning a Chart in VBA

SBF12345

Well-known Member
Joined
Jul 26, 2014
Messages
614
I am working on putting together some charts in VBA and could use some assistance with defining properties in the chart.

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?
 

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.

Forum statistics

Threads
1,223,704
Messages
6,173,984
Members
452,540
Latest member
haasro02

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top