![]() ' remove chart border: THIS IS WHERE I'M HAVING TROUBLE.ĪctiveChart.Axes(xlValue).MajorGridlines.SelectĪctiveSheet.Shapes("Chart 1").Line.Visible = msoFalseĪctiveChart.Axes(xlValue, xlPrimary).HasTitle = TrueĪctiveChart.Axes(xlValue, xlPrimary).AxisTitle.Characters. This is a sample data set: Data1 Data2 Data3Īnd this is my current code: Sub MakeCharts2()Ī2(227, xlLine).SelectĪctiveChart.SetSourceData Source:=Range("A1:D9")ĪctiveChart.Location Where:=xlLocationAsNewSheet, Name:="Chart_" & strSheetName Change the gridlines: In the Gridlines section of the sidebar, click the buttons to add or remove gridlines from the table body, from the header rows and columns, and from. Do any of the following: Change the outline: In the Table Outline section of the sidebar, use the controls to change the line type, thickness, and color. ![]() Tutorial 3: Writing different types of data to the XLSX File. Click the table, then in the Format sidebar, click the Table tab.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |