How do I add spaces to chart labels before and after data?
Hi!
I have a vertical bar graph with 2 data points (budget and actual). Along the X-Axis I can easily get the ColLabels for FISCALYEAR. Works like a charm.
The issue is that the user wants to see TWO ColLabels on the X-Axis. They want the FISCALYEAR and the Percent to Budget. I tried adding another label to ColLabels for PERCENT_TO_BUDGET, but it only shows one label at a time (which seems to be the design when using the chart wizard - you can only chose a single label).
Then I thought I'd be clever and put the 2 data field together in one label - which works. The problem is that I need to get each data point on a separate line (percent above fiscal year).
I have a vertical bar graph with 2 data points (budget and actual). Along the X-Axis I can easily get the ColLabels for FISCALYEAR. Works like a charm.
The issue is that the user wants to see TWO ColLabels on the X-Axis. They want the FISCALYEAR and the Percent to Budget. I tried adding another label to ColLabels for PERCENT_TO_BUDGET, but it only shows one label at a time (which seems to be the design when using the chart wizard - you can only chose a single label).
Then I thought I'd be clever and put the 2 data field together in one label - which works. The problem is that I need to get each data point on a separate line (percent above fiscal year).
0