gaqsmile.blogg.se

These values can be in rows or columns on the worksheet, but they must be in the following order: x value, y value, and then z value. Three values per data point Three values are required for each bubble. In this bubble chart, the number of products is displayed along the horizontal axis, the sales amounts are displayed along the vertical axis, and the market share percentages are represented by the size of the bubbles.Ĭonsider using a bubble chart when your data includes the following: For example, organize your worksheet data as shown in the following picture. To create a bubble chart, arrange your data in rows or columns on a worksheet so that x values are listed in the first row or column and corresponding y values and bubble size (z) values are listed in adjacent rows or columns. Different bubble sizes are useful to visually emphasize specific values.

Bubble charts are often used to present financial data. The sizes of the bubbles are determined by the values in the third data series. The rigid matrix math calculation for this intersection is 451718.964Īs I examine these graphs in detail, the position of the two line segments moves relative to the major grid lines and that is why the apparent intersection is different on each graph.You can use a bubble chart instead of a scatter chart if your data has three data series that each contain a set of values. If I graph this data using an X/Y Scatter plot I get the following apparent intersections: The more I "rescale in", the farther from the calculated intersection the lines appear to cross.įor example, consider the following simplified case:

Unfortunately, I noticed that the apparent intersection does not remain consistent as I "zoom" in by changing the X/Y scales on my charts.

I can calculate the exact intersection by defining the equation for each of these lines and solving them simultaneously, but I need the "map" to provide visual impact for my "audience". In its simplest form, I am graphing two line segments and illustrating where they intersect. I am using Excel to plot directional data from a horizontal well to determine where the wellbore crosses specific geographic boundaries.