Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Frank Cazabon
  Where is Frank Cazabon?
 
 Trinidad And Tobago
 Frank Cazabon
 Tags
Subject: Excel Chart Fontsize
Thread ID: 365340 Message ID: 365340 # Views: 41 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Active X Controls & OLE Automation
Date: Monday, December 24, 2012 11:52:55 AM         
   


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.

Frank Cazabon
Samaan Systems Ltd.
www.SamaanSystems.com

ENTIRE THREAD

Excel Chart Fontsize Posted by Frank Cazabon @ 12/24/2012 11:52:55 AM
RE: Excel Chart Fontsize Posted by Koen Piller @ 12/24/2012 3:03:55 PM
RE: Excel Chart Fontsize Posted by Frank Cazabon @ 12/24/2012 4:18:51 PM
RE: Excel Chart Fontsize Posted by Cetin Basoz @ 12/24/2012 3:24:57 PM
RE: Excel Chart Fontsize Posted by Frank Cazabon @ 12/24/2012 4:17:43 PM