View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
navin navin is offline
external usenet poster
 
Posts: 32
Default Changing the font size in the charts

Hi,

In a spreadsheet i have, some 20 charts along with the data. I have to
reduce the font size for the x and y axis and the title. For one chart
i can use the active chart method to achieve.

Please tell me, how i can loop through all the charts in the sheets
and reduce the fonts.

Please help.

Thanks,
Navin