How do I change the font size of a graph in Excel.

[hellbound]

I'm looking for a way to change the font size of everything in a graph in excel using foxpro. My graph comes out with all the info but the fonts are to big to display it all properly I need to make it a bit smaller. Thanks for any and all help.

 

[jenwelch]

To change all text on chart to a single font size, set the ChartArea object's font:

with oChartObject.ChartArea.Font
.Name = "Arial"
.Size = 8
endwith

If you need different objects to have different fonts, you will have to access the objects individually (example here is chart title):

with oChartObject.ChartTitle.Font
.Name = "Arial"
.Size = 8
endwith

I hope this helps.

 

[HERVEC1]

Hi Where I can find the all code to define an excel chart thru foxpro like the title ,the font etc....

thanks

 

[Mike Gagnon]

HERVEC1

There are a couple of samples in VFP's "solutions".
May I suggest if you have a question on your own, that you create a new thread, instead on adding a question to someone else's thread.
Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first