If you have been playing with the chart in Word or Excel you might encountered that the point on the graph is quite small.
If you need to adjust the data point on Word graph, you have two options do it manually or simply automate it at runtime using a VBA code.
Assuming you have all the necessary parameters that creates the graph via VBA, and you just need to adjust the data point you can use the code below, the code below was tested using Word 2016. It may not apply to older versions but I think logic should stay the same.
cht.SeriesCollection(1).Format.Line.Weight = 9.75
To do it manually, click on the data point and right click on it and select “Format Data Point”, click the bucket icon and change the width value.
Here’s the screen shot using Word 2016:
For the sake of completeness, the code will be something like this:
Dim shp As Shape
Dim cht As Chart
Set shp = ActiveDocument.Shapes.AddChart(xlXYScatterLines)
Set cht = shp.Chart
Dim wb As Excel.Workbook
Dim ws As Excel.Worksheet
cht.SeriesCollection(1).Format.Line.Weight = 9.75 'change the width value to a desired one
Output will be something like this, the data point is quite big.
Cheers! Till next time.
Free Android Apps:
Linux Android App cheat sheet:
Multiplication Table for early learners
Catholic Rosary Guide for Android:
Divine Mercy Chaplet Guide (A Powerful prayer):