| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
how to change font size of datalabels of two charts in a sheet
hey guys i have two charts in a sheet how to change the font size and AutoScaleFont of datalabels in them through VBA?? -- amrezzat ------------------------------------------------------------------------ amrezzat's Profile: http://www.excelforum.com/member.php...o&userid=28766 View this thread: http://www.excelforum.com/showthread...hreadid=540051 |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
how to change font size of datalabels of two charts in a sheet
The required syntax is discoverable using the macro recorder. The final
result would look something like this: For Each chtob In ActiveSheet.ChartObjects For Each srs In chtob.Chart.SeriesCollection If srs.HasDataLabels Then srs.DataLabels.Font.Size = 8 srs.DataLabels.AutoScaleFont = False End If Next Next - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "amrezzat" wrote in message ... hey guys i have two charts in a sheet how to change the font size and AutoScaleFont of datalabels in them through VBA?? -- amrezzat |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I change column size for lower half of sheet? | Excel Discussion (Misc queries) | |||
| Combo Box font size in Charts | Charts and Charting in Excel | |||
| How can i change the font size of the items in a list | Excel Discussion (Misc queries) | |||
| Can one change the font or format of a sheet name? | Excel Discussion (Misc queries) | |||
| Change datalabel font size for all chartobjects in a row | Charts and Charting in Excel | |||
Linear Mode
