Share via

Can you change the text alignment of a Data Table in a Pivot Chart?

Anonymous
2022-02-04T18:23:01+00:00

I want to change the text alignment of the Data Table in a PivotChart made in the Stacked Column format, but the Text Box settings under Format Data Table > Text Options > Textbox are grayed out. Is there another method?

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-02-04T18:33:40+00:00

    Can you show us an example of your starting point and the ending point you want?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2022-02-04T19:09:48+00:00

    I'm starting with a pivot table:

    from which I make a PivotChart:

    with an attached Data Table:

    I'd like all of the "Junk Data" tags to have a vertical text direction.

    2 people found this answer helpful.
    0 comments
  3. Anonymous
    2022-02-04T23:49:19+00:00

    OK, I think I got it. You want the labels "Junk Data #" to be rotated 90 degrees.

    Right click on one of the data labels, to select the whole block

    Select "Format Axis" option to display the Format Axis Pane

    In the Format Axis pane > Axis Options > Size & Properties (3rd hieroglyphic icon) > Text Direction > pick which way you want to rotate it.

    2 people found this answer helpful.
    0 comments