NigelTufnel
Board Regular
- Joined
- Apr 3, 2008
- Messages
- 53
- Office Version
- 365
- Platform
- Windows
Short question: Is it possible to read the width of a single bar in a Bar Chart using VBA?
Here's the application: I'm creating a series of bar charts that have a varying number of categories and series. However, if possible, I'd like to impose a uniform width for the bars in the charts. It's OK if the charts are different overall sizes, it would just look better if all the bars within the charts were uniform.
I know I can change the bar sizes by manipulating the "Gap width"--but this adds space between the categories, and I don't want that.
So, instead, I'd like the re-size the plot areas so that the the bars (and spaces between the categories) stay the same. I can do this manually, but I might be able to automate this if I could somehow read the original bar widths and if I knew the desired bar width.
Any thoughts/comments?
Here's the application: I'm creating a series of bar charts that have a varying number of categories and series. However, if possible, I'd like to impose a uniform width for the bars in the charts. It's OK if the charts are different overall sizes, it would just look better if all the bars within the charts were uniform.
I know I can change the bar sizes by manipulating the "Gap width"--but this adds space between the categories, and I don't want that.
So, instead, I'd like the re-size the plot areas so that the the bars (and spaces between the categories) stay the same. I can do this manually, but I might be able to automate this if I could somehow read the original bar widths and if I knew the desired bar width.
Any thoughts/comments?
