Size of a datapoint on a scatter chart related to a "third column" of data

[phil152003]

Got another spreadsheet to create for my boss. On it, there are different datapoints for each client, but he wants the size of each datapoint to be determined by income (large income -> large data point for example). Now I know I could go through each point manually and change it, but there are hell of a lot of clients, and the chart is based on pivot data, so the data will constantly change depending on the filters selected.

Is there any vba code (or any other way) so that the size of the datapoint is automated depending on the third colum?

I'm going to have a play myself, but I'm very new to this, so its highly unlikey I'll be able to solve it myself.

Thanks for any input.

 

[GlennUK]

Look at Bubble chart type.

 

[phil152003]

... D'oh.


I've been using Excel for quite a few years, but I've never needed to use a bubble chart. I thought my boss' request was something unusual that would require a relatively complex implementation. Apologies for the thread, but thanks for answering so quickly.

 

[GlennUK]

My pleasure!