Column chart, when set x axis text orientation to 45 degree, first text name always shorten. Please advise or fix.

[leonjxtan]

Hi, as in attached pic.
My use case is that I have a column chart with reasonably many columns, so that if I do not set orientation to 45 degree, all names are shortened to "xxx...yyy"

But after setting orientation to 45 degree, my boss found that the first column, no matter how short the name is, will always be shortened to "xxx...yyy". I tried to switch to several different data set, and problem still persist.
In the attached pic example, the "Ada...itz" is only 10 characters in length; the "Anthony xxxxxx" is 14 characters in length, but it is not shortened.

Could you please advise if I configured the chart wrong, or could you please help to fix this problem?

Thanks.

[leonjxtan]

@adonio, I created another column chart from GUI wizard, and pasted all options tags in your code to the column chart source code, but still seeing first column text being shortened.

at the same time, I confirmed that if I change the orientation to horizontal, the name can be displayed correctly.

Could you further advise? The Splunk Enterprise version in my company is 6.5.2, if this helps.

[adonio]

tried here and seems to work as anticipated:
code:

<dashboard>
  <label>legend attempt</label>
  <row>
    <panel>
      <chart>
        <search>
          <query>index = _internal | stats count by sourcetype</query>
          <earliest>-4h@m</earliest>
          <latest>now</latest>
          <sampleRatio>1</sampleRatio>
        </search>
        <option name="charting.axisLabelsX.majorLabelStyle.overflowMode">ellipsisNone</option>
        <option name="charting.axisLabelsX.majorLabelStyle.rotation">-45</option>
        <option name="charting.axisTitleX.visibility">visible</option>
        <option name="charting.axisTitleY.visibility">visible</option>
        <option name="charting.axisTitleY2.visibility">visible</option>
        <option name="charting.axisX.scale">linear</option>
        <option name="charting.axisY.scale">linear</option>
        <option name="charting.axisY2.enabled">0</option>
        <option name="charting.axisY2.scale">inherit</option>
        <option name="charting.chart">column</option>
        <option name="charting.chart.bubbleMaximumSize">50</option>
        <option name="charting.chart.bubbleMinimumSize">10</option>
        <option name="charting.chart.bubbleSizeBy">area</option>
        <option name="charting.chart.nullValueMode">gaps</option>
        <option name="charting.chart.showDataLabels">none</option>
        <option name="charting.chart.sliceCollapsingThreshold">0.01</option>
        <option name="charting.chart.stackMode">default</option>
        <option name="charting.chart.style">shiny</option>
        <option name="charting.drilldown">none</option>
        <option name="charting.layout.splitSeries">0</option>
        <option name="charting.layout.splitSeries.allowIndependentYRanges">0</option>
        <option name="charting.legend.labelStyle.overflowMode">ellipsisMiddle</option>
        <option name="charting.legend.placement">right</option>
        <option name="trellis.enabled">0</option>
        <option name="trellis.scales.shared">1</option>
        <option name="trellis.size">medium</option>
      </chart>
    </panel>
  </row>
</dashboard>

screenshots:

[leonjxtan]

Hi @adonio, sorry had to post my reply in main comment as only there allows me to attach picture. Could you please advise?

Thanks.

[oda]

I think that it will not be a fundamental solution but I think that it will work if it is 45.
Not -45.

[leonjxtan]

@oda thanks it works!

@Splunk could you add this to the bug queue? 🙂

[woodcock]

If it really is a bug, add the bug tag and also open a P2 support case with your entitlement.