Hello @balupad14 and All
This Details.xlsx (9.4 KB) is the excel from which i am trying to create Column chart.
if i consider only first 2 rows(A1:E3) for Charting, the chart looks like below.
However, column chart for all the 5 rows looks different. Rows and Columns are exchanged.
Question1: I would like to have 2nd result always regardless of number of row selection. How can we achieve that
Question2: Can we set chart width dynamically? because based on the number of row considered, the chart width should vary.
Question3: in 2nd chart, is it possible to make the numbers set inside the bar and vertically. So that it doesnt look overlapping.
Question4: I need to have separator between the column bars. Specially in 2nd chart- between 2 column. 2 column of each set among 4.
Your inputs will be highly appreciated.