Questions

HELP! Is there anyway to make a bar pivot chart print all row labels?

Tags:
+
0 Votes
Locked

HELP! Is there anyway to make a bar pivot chart print all row labels?

starr.cruise
All my row labels show when I do a column chart. I am using a bar chart in two other places and all the labels are showing. Each row has data - it is not empty, but the bar chart is skipping every other row label.
  • +
    0 Votes
    starr.cruise

    Geez -I accidentally figured it out. Right Click on Row label section of chart, choose Format Axis. In this case, I had to take it off Automatic under "Interval between labels" and select Specify interval - which defaults to 1 which was what I needed. Maybe everyone else knew that, but it took me a while. Maybe someone can use this.

    +
    0 Votes
    fledis

    Just make whole chart bigger dragging the corner (down-right or up-right). Or Format Axis and set Font Size smaller.

  • +
    0 Votes
    starr.cruise

    Geez -I accidentally figured it out. Right Click on Row label section of chart, choose Format Axis. In this case, I had to take it off Automatic under "Interval between labels" and select Specify interval - which defaults to 1 which was what I needed. Maybe everyone else knew that, but it took me a while. Maybe someone can use this.

    +
    0 Votes
    fledis

    Just make whole chart bigger dragging the corner (down-right or up-right). Or Format Axis and set Font Size smaller.