If that modification would cause the break to fall completely outside the data range, or cause the size of the break to be extremely small, the break will be removed entirely. 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). 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |