Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-30-2014, 10:01 AM
shilabrow shilabrow is offline Chart Formating with ChartTitle Font and DataLabel Formating Windows Vista Chart Formating with ChartTitle Font and DataLabel Formating Office 2007
Advanced Beginner
Chart Formating with ChartTitle Font and DataLabel Formating
 
Join Date: Apr 2014
Posts: 45
shilabrow is on a distinguished road
Default Chart Formating with ChartTitle Font and DataLabel Formating

1. I am trying to format chart's fonts and insert Label.

When I recorded macro it records fine but does not show the code behind hence not working. I successfully tried to change the Axis and legend font but unable to change the title font. HEre is the code I used for the legend and axis. All help in setting the Charttitle font will be appreciated.

ActiveChart.Axes(xlCategory).Select
With Selection.TickLabels.font
.Size = 12
' .Bold = False


.Name = "Cambria"
End With

With ActiveChart.Axes(xlValue).AxisTitle
.font.Name = "Cambria"
.font.Size = 12
End With

I need to set the Chart Title as Cambria Font as well.


2. Also I recorded the data Label - i.e. Chose the option Add Data label to the chart but doesnt work. How Do I add the Data label into the chart and drag them into the top of my bar (I want to place them on top of bar and change color to white) I cant seem to see how to get this done. I appreciate your assisting me. THanks.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formating for buletts YooNaa Kim Word 5 05-04-2012 11:49 PM
Chart Formating with ChartTitle Font and DataLabel Formating more Conditional Formating princeofsadness Excel 2 09-05-2011 02:14 AM
Macro for chart formating QWERTY_Warrior Excel Programming 0 06-29-2011 07:38 AM
After formating PC milkmile Outlook 2 10-12-2010 06:58 AM
formating apostrophes ckconti Word 0 10-20-2009 07:09 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:36 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft