Excel for mac maximum x axis

broken image
broken image

Therefore, changing the data after a break has already been created, could cause the break to grow, shrink or move to meet the above requirements. The size of the break will always be set to the maximum size that it could take up without violating one the above rules. For a bubble chart, the break will only display on the axis, not on the bubble. For a scatter chart, none of the points can be within the break, and for a line or area chart, none of the vertices can be within the break (although the lines connecting vertices can cross a break).

broken image

Axis breaks can be applied to a Y or a 2Y axis.įor a bar chart, the boundary between segments of a bar cannot fall within an axis break. Axis breaks can be used to shrink a particularly large segment and enhance readability for the smaller segments in your chart.Īny break you insert applies to the axis and to all segments sharing the same range of the axis.