Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Cetin Basoz
  Where is Cetin Basoz?
 Izmir
 Turkey
 Cetin Basoz
 To: Frank Cazabon
  Where is Frank Cazabon?
 
 Trinidad And Tobago
 Frank Cazabon
 Tags
Subject: RE: Excel Chart Fontsize
Thread ID: 365340 Message ID: 365343 # Views: 39 # Ratings: 1
Version: Visual FoxPro 9 SP2 Category: Active X Controls & OLE Automation
Date: Monday, December 24, 2012 3:24:57 PM         
   


> 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

Maybe double the size?

.ChartTitle.Font.Size = .ChartTitle.Font.Size * 2




Cetin Basoz

.Net has got better.Think about moving - check my blog:
My Blog
Blog (mirror) - sounds to be down


Support Wikipedia

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