PC Review


Reply
Thread Tools Rate Thread

Change Graph X Axis Font Size

 
 
New Member
Join Date: Jan 2006
Posts: 2
 
      20th Jan 2006
I am creating slides and loading a graph on a slide completely via VBA. In my graph's datasheet, I have the text in the first row that shows underneath the series of data:

ex. of the Data Sheet

Code:
      		Initial Reaction
      Concept 1	45
      Concept 2	68
      Concept 3	89
The "Initial Reaction" text will show along the X-axis of the chart. However, I want to change the font size of that text only. The Y-axis shows 0 to 100 in the default font size, and I want to keep it that way. In Powerpoint itself, I can active the graph, right click on the text "Initial Reaction", and select 'Format Axis'. This brings up Powerpoint's tabbed formatting window so I can change the font size.

I can't seem to find the object heirarchy to programmatically change the font of the text. Any ideas? I can assign .ChartArea.Font.Size = 12, however that changes all of the font sizes, including the Y-axis which I want as-is.

Here is a screenshot of what I need to access programmatically as described above:


Last edited by HardCode; 20th Jan 2006 at 08:21 PM..
 
Reply With Quote
 
 
 
 
New Member
Join Date: Jan 2006
Posts: 2
 
      23rd Jan 2006
I'll bump this once, hoping for a reply
 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
RE: Graph axis / centre location change Luke M Microsoft Excel Misc 0 16th Jun 2009 06:02 PM
How can I change font size, font type, page size etc. permanently? ferroburak Microsoft Word Document Management 2 2nd Jan 2009 03:03 PM
Re: How do I change value of Y axis on graph Andy Pope Microsoft Excel Charting 0 6th Dec 2006 01:46 PM
how do i change the x-axis of a graph to a log scale? =?Utf-8?B?YW5uZQ==?= Microsoft Excel Charting 3 13th Apr 2006 07:30 PM
How do you change the values of a graph on the x-axis? =?Utf-8?B?dG1hbjIyNA==?= Microsoft Excel New Users 1 13th Oct 2005 01:24 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 11:38 PM.