ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How can I set width of the columns in the column graph? (https://www.excelbanter.com/charts-charting-excel/122432-how-can-i-set-width-columns-column-graph.html)

yulia

How can I set width of the columns in the column graph?
 
I need to make 10 graphs with different number of columns, but Excel resizes
column width each time I add additional column to the graph. I need all 10
graphs to have equal column width independently of how many columns in the
graph.

toni.gee

How can I set width of the columns in the column graph?
 
As a work around, include datapoints for all graphs to the maximum number
required for any one graph. For the datapoints that are not relevant on each
graph, include a value of zero. These will exist, but not display, and will
occupy the same space on the axis thereby forcing the columns to equal widths.

"yulia" wrote:

I need to make 10 graphs with different number of columns, but Excel resizes
column width each time I add additional column to the graph. I need all 10
graphs to have equal column width independently of how many columns in the
graph.



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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com