Scatter graph- how to show multiple entries?

[christian73]

Hi

I have a scatter graph to show actual times against expected times for a ranghe of ages (age is the X axis). In some cases there are several entries at each point- e.g. 4 people with an expected time of 32 minutes came in at 34 minutes. Currently the chart just displays one marker at this point- is there any way I could use another symbol to show that there are multiple entries at this plot point?

Many thanks

[Andy Pope]

You would need to create another series, based on formula, for each multiple point.

If you need more help post example workbook

[christian73]

Thanks Andy, I'll have a play with that.

Take care