Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Legends in a pie chart in excel 2000

I keep running into a problem and i could use some help with either a
creative solution or new way to address the problem

I'm trying to create a pie chart (3dexploded) and it appears as though
there's some sort of limitation about the amount of text I can use in
the legend. I'm using arrays instead of ranges for data points and
labels. It ends up choking when do

with chrtCreate.SeriesCollection(1)
.Xvalues = vLabels
end with

There's about 17 points (pie slices if you will) and the xValues
assignment chokes (as best I can tell) when there is one label that is
greater than 15 characters and contains more than one space.


Now cutting down the length of the labels is absolutely nonnegoitable.

Is there some other way of assigning labels for the pie chart or anyone
have any suggestions on how to make this work?
Reply
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
HOW TO ADD LEGENDS IN CHART S. LALLY Excel Discussion (Misc queries) 1 April 9th 10 01:46 AM
Dynamic chart legends anton Charts and Charting in Excel 1 September 5th 08 02:03 PM
Chart Legends Tina Charts and Charting in Excel 1 March 20th 07 07:22 PM
Excel Chart Legends need alignment option (rotate 90-180-270 deg) ron ebelhar Charts and Charting in Excel 2 August 29th 05 06:13 PM
Problem with Legends in chart n/a Excel Programming 6 October 29th 03 03:33 PM


All times are GMT +1. The time now is 03:26 PM.

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

About Us

"It's about Microsoft Excel"