Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Chart Datalabels
Does any know how to change the default font for DataLabels on an Excel
chart?. When you turn on Datalabels they always seem to be in Arial 12pt size. This means that I have to programatically change the Font/Size/etc for every series in the chart to get the desired effect I cannot help thinking that there must be an easier way but I simply cannot find it. Sean P.S. Does anyone have an idea why the ApplyDataLabels method does not work in Microsoft Graph? *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Chart Datalabels
The easiest way to get round this one is to record a macro of you setting up
a new graph and changing the data label font size, then cut and paste it into your existing Macro/VB. I know this isn't exactly what you want, sorry. Ric "Sean Howard" wrote in message ... Does any know how to change the default font for DataLabels on an Excel chart?. When you turn on Datalabels they always seem to be in Arial 12pt size. This means that I have to programatically change the Font/Size/etc for every series in the chart to get the desired effect I cannot help thinking that there must be an easier way but I simply cannot find it. Sean P.S. Does anyone have an idea why the ApplyDataLabels method does not work in Microsoft Graph? *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Chart Datalabels
dear ric,
I don't think that one is a go missus. I already know how to set the datalabel font in vb. My question is HOW does Excel decide what the initial font/size for datalabels is, and can I change this initial value to something else Sean *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Chart Datalabels
Sean -
In Tools Options General, you can select the default font. This is applied to cells, and to most text elements of a chart: data labels, axis tick marks, legend entries. The axis titles are the same, with Bold added, and the chart title is somewhat larger, in bold. If you change this to change the data label font, everything else also will change. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Sean Howard wrote: Does any know how to change the default font for DataLabels on an Excel chart?. When you turn on Datalabels they always seem to be in Arial 12pt size. This means that I have to programatically change the Font/Size/etc for every series in the chart to get the desired effect I cannot help thinking that there must be an easier way but I simply cannot find it. Sean P.S. Does anyone have an idea why the ApplyDataLabels method does not work in Microsoft Graph? *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Chart Datalabels
Thanks Jon,
That works, but unfortunately you have to re-start Excel, which from a programming view is a bit a of a pain to say the least. Along the same lines do you know how to achieve the same thing (like the standard font in Excel) in Microsoft Graph? Sean *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Chart Datalabels
Sean -
I hope you're not changing the user's default settings. That'd tick me right off! - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Sean Howard wrote: Thanks Jon, That works, but unfortunately you have to re-start Excel, which from a programming view is a bit a of a pain to say the least. Along the same lines do you know how to achieve the same thing (like the standard font in Excel) in Microsoft Graph? Sean *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Chart Datalabels
Perish the thought Jon. It just seems a strange thing to have to
manipulate OUTSIDE the chart object (who knows how to do the equivalent in MS Graph). I think Uncle Bill has let be down again Sean *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lock the chart but leave datalabels position editable | Charts and Charting in Excel | |||
How to assign datalabels to a scatter chart, obtaining the labels. | Excel Discussion (Misc queries) | |||
Accessing PowerPoint datalabels from excel VBA | Excel Programming | |||
Datalabels on Scatter | Excel Programming | |||
Converting DataLabels to Numbers | Excel Programming |