#Filterable scatter chart excel download#

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.

#Filterable scatter chart excel 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.