LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Richard
 
Posts: n/a
Default Dynamic Bar Chart Category Axis Problem

Hi

I have created a dynamic bar chart, roughly based on Stephen Bullen's
funchrt4. The number of categories can range from 2 to about 50 and ideally I
would like the category axis names font to be Arial 10 at least.
When the number of categories gets towards 50, the category axis names
disappear altogether and the only way I have found to retrieve them is to
manually reduce the font size to about 7 (dependent on the level of the
zoom). This font size is excessively small for the majority of charts.
Is there any way to get Excel2002 to keep the category axis names in all
circumstances without reducing them all to a very small font size?

--
Thanks

Richard
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Right axis instead of left axis in chart saturnin02 Excel Discussion (Misc queries) 5 April 29th 23 11:42 AM
Dynamic bar chart, must ignore "n/a" data... paris3 Charts and Charting in Excel 4 June 26th 05 07:07 PM
Fan charts Dean Charts and Charting in Excel 7 May 30th 05 11:51 AM
Stacked Bar Chart with Secondary Axis Benjamin B Charts and Charting in Excel 7 May 15th 05 04:00 AM
Formatting dates on x axis of chart...! saturnin02 Excel Discussion (Misc queries) 4 January 27th 05 08:55 PM


All times are GMT +1. The time now is 05:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"