Here, for example, the inner box is 93% of the size of the outer box. The Scale setting above the table specifies about how large each new rotated shape should be compared with the shape that precedes it. Points 6 through 10 define the position of the next box, which is slightly rotated, as shown in this figure. The remaining three points draw the rest of the square, completing it at point 5 in the table…a point that has the same values as point 1. These two sets of points define the blue vertical line at the left side of the chart’s Plot Area. Point 2 is at the top-left corner, where the X value equals 0 and the Y value equals 1. Point 1 in the table is at the bottom-left corner of the blue square, where both the X and Y values equal zero. To illustrate, the first five points in this table define the blue square that outlines the top-left chart above, and for the simple chart below. And if the chart shows lines, like the charts above do, the chart requires two pairs of values for each line: a starting point and an ending point for each line segment. Unlike typical line charts, each point of an XY chart requires two values: an X position and a Y position. So let’s create one of these charts… Introducing the Square XY Chart But I included the axes so you could see that they really are Excel charts. Normally, if I were going to display these figures as an example of computer art, I’d hide the X and Y axes of the charts. My inspiration for these designs came from an article that Daniel Gasteiger wrote in LOTUS magazine about 30 years ago, when I also wrote for the magazine. And the remaining charts show the same charting techniques applied to different shapes. The last chart relies on random numbers for its initial data. The first two charts above are from the same chart object, but with two different settings. Honestly, I can’t think of a practical use for any of them, but they definitely are fun to play with. These charts are the result of my play time.
#Scatter chart excel triangle not centered download#
(You can download the workbook with these and additional example charts here.) Unlike line charts, XY charts plot points and lines by specifying both the X and Y values. Because I’d been working hard on a project for many months, I once decided to take a break and play around with XY charts…which also are known as scatter charts.