data markers in xy scatter charts

scattered · Feb 25th, 2002, 12:02 PM

How can I do the following to data in a scatter chart?

For a given set of plotted coordinates (x,y) I want to associate another value that will then plot to scale as the data marker in the scatter chart.

For example, if coordinates (x1, y1) represent a project of size A, and coordinates (x2, y2) represent a project of size twice as large as A, the data marker for the second project will be depicted as twice as large as that the first on the scatter chart.

Also, as a variation of the same principle, how do I bracket the sizes of the data markers? For example, if I want the data markers for projects between size 0 and 2xA to be depicted with one size and those for projects between 2xA and 4xA with another size, and those between 4xA and 10xA with a third size, how can I do that?

Mark W. · Feb 25th, 2002, 12:04 PM

Sounds like a bubble chart. Have you considered this chart type? Suppose A1:B4 contains {"X","Y";1,2;3,4;4,3}. You could enter the formula, =B2/MAX(B:B) or =B2/MIN(B:B), into C2 and fill down to C4. Next, select A1:C4, choose the Bubble Chart type from the Chart Wizard, select "Series in columns" at Step 2 of 4, and press [ Finish ].

[ This Message was edited by: Mark W. on 2002-02-25 11:28 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 25th, 2002, 12:02 PM	#1
scattered New Member Join Date: Feb 2002 Posts: 3	How can I do the following to data in a scatter chart? For a given set of plotted coordinates (x,y) I want to associate another value that will then plot to scale as the data marker in the scatter chart. For example, if coordinates (x1, y1) represent a project of size A, and coordinates (x2, y2) represent a project of size twice as large as A, the data marker for the second project will be depicted as twice as large as that the first on the scatter chart. Also, as a variation of the same principle, how do I bracket the sizes of the data markers? For example, if I want the data markers for projects between size 0 and 2xA to be depicted with one size and those for projects between 2xA and 4xA with another size, and those between 4xA and 10xA with a third size, how can I do that?

Feb 25th, 2002, 12:04 PM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	Sounds like a bubble chart. Have you considered this chart type? Suppose A1:B4 contains {"X","Y";1,2;3,4;4,3}. You could enter the formula, =B2/MAX(B:B) or =B2/MIN(B:B), into C2 and fill down to C4. Next, select A1:C4, choose the Bubble Chart type from the Chart Wizard, select "Series in columns" at Step 2 of 4, and press [ Finish ]. [ This Message was edited by: Mark W. on 2002-02-25 11:28 ]