Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Excel Chart Fontsize
Message
De
24/12/2012 14:48:27
 
 
À
24/12/2012 05:56:36
Information générale
Forum:
Visual FoxPro
Catégorie:
COMCodebook
Versions des environnements
Visual FoxPro:
VFP 9 SP2
Divers
Thread ID:
01560536
Message ID:
01560568
Vues:
44
>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform