Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel Chart Fontsize
Message
From
24/12/2012 14:48:27
 
 
To
24/12/2012 05:56:36
General information
Forum:
Visual FoxPro
Category:
COMCodebook
Environment versions
Visual FoxPro:
VFP 9 SP2
Miscellaneous
Thread ID:
01560536
Message ID:
01560568
Views:
43
>Hi,
>
>I generate an excel file with a chart in it. The size of the text in the chart gets too small to read easily so I'm trying to increase it. Here is my code that is not working. Anyone know what I need to do?
>
>
m.loChart = m.loXLWorkbook.Charts.Add()
>
>With m.loChart
>	.ChartType = xl3DPieExploded 
>	.Location(xlLocationAsNewSheet)
>	.PlotArea.Border.LineStyle = xlNone
>	.PlotArea.Interior.ColorIndex = xlNone
>	.HasTitle = .T.
>	.ChartTitle.Characters.Text = "Claims Settlement Breakdown"
>	.ApplyDataLabels(2,.F.,,,,.T.,.F.,.T.)
>	.SeriesCollection[1].DataLabels.AutoScaleFont = .T.
>	.SeriesCollection[1].DataLabels.Font.Size = oAppInfo.ChartDataLabelsFontSize
>	.HasLegend = .F.
>EndWith
Frank,
Try FoxCharts.app
Best regards,
Koen
Previous
Reply
Map
View

Click here to load this message in the networking platform