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
 To: Cetin Basoz
  Where is Cetin Basoz?
 Izmir
 Turkey
 Cetin Basoz
 Tags
Subject: RE: Excel Chart Fontsize
Thread ID: 365340 Message ID: 365344 # Views: 33 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Active X Controls & OLE Automation
Date: Monday, December 24, 2012 4:17:43 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

>

Thanks, but it seems this is just not "taking". I have even tried changing the font to make it obvious that something is happening, but the font isn't being changed, so I am apparently referencing the wrong thing. I'll have to do some more digging after Christmas.

Merry Christmas!

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