How to create Buffer between x axis and x axis Category label of that chart
Cristina (BOB member since 2009-02-27)
Hi Cristina,
If you mean how to insert extra margin or blank space between x-axis and it’s labels, then it depends on whether your axis labels are fixed or dynamic.
In case of fixed label cells, you can insert a newline character (Alt+Enter) just before the label value in the spreadsheet cell. Insert as many as you need.
If the label values are dynamically generated (from query), then we need at least the number of cells. In case same number of cells are going to be used always, then you can use a formula to prefix your label values with newline character. E.g., if first label is in cell A2, then you give the following formula in A1: (="<press alt+enter>"&A2) and so on. Then use these new values as your x-axis labels.
But if the number of labels is also not known, then the only option I can think is using the IF statement with the above formula to handle blank cells. But IF statements are an over-head for performance.
Hope it helps.
Isha
mehak83 (BOB member since 2011-06-28)