View Single Post
  #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