LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
 
Posts: n/a
Default Bar Chart Label Sizes

I am dynamically populating multiple Horizontal Bar Charts with Data. I
want the Labels (y axes) and chart area (Bar Charts) to be the same on
each chart. When I dynamically set the data the labels and charts
resize themselves based on the width of the data.

Is there a way through code VBA, C#, etc that I can set the width of
the Graphic (the bar charts --no labels) independently of the width of
the labels (the y axis). I haved tried xlChart.Chart.PlotArea.Width but
it appears to be the width of both of these areas together? Any other
thoughts.

Thanks In Advance

 
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
Impedding/Overlaying Charts Phil Hageman Charts and Charting in Excel 4 December 17th 04 07:25 PM
Chart Label wraps on the same line. "Wavelenght [nm]" appears as. rog Charts and Charting in Excel 1 December 15th 04 08:10 PM
pivot table multi line chart souris Charts and Charting in Excel 2 December 7th 04 03:56 AM
the dates to label the x axis on the scatter chart won't print waterlady Charts and Charting in Excel 0 November 29th 04 06:44 PM
Why do my text boxes disappear from my chart when I click out? Robboo Charts and Charting in Excel 1 November 27th 04 05:49 PM


All times are GMT +1. The time now is 08:33 AM.

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"