I am trying to create chart using templates. I have attached an output file. The chart’s source data might vary each time I create a chart. Sometimes there may be just 3 columns and sometimes there may be 10 columns. The output chart width should be width of all the columns for it’s source data. I could not find a relation betweeen the column width and the chart size. Could you please help me in calculating the same, so that I can resize the chart width based on the source column widths?
Hi,
Well, generally, I think the width of the individual bars/columns in the chart depends on the chart’s plot area /chart area or even chart’s size. If you extend these objects’ width, you might get bigger bars/columns in the chart. And, if you decrease the width of these objects, you will see the bars width are minimized and you might see some labels in value axis/category axis or even legend entries missing too.
Thank you.