Help with plotting data on Scattergraph

[crazytimechris]

Hi Guys,

I have made a scatter-graph to show me data as if they are points on a map. I now have the problem that sometimes in my data the point will be repeated. How can i combine the data so that the point shows up once in the graph and the data lable shows the total amount.

\1


You see on the right I have filtered the data but sometimes the area shows up twice due to different times. but the lables will be on top of each other on the scatter graph...

Thank you for any thoughts or input!


CtCMicrosoft Excel - Taxi Service 2014 WORK 03122014.jpg

[Andy Pope]

You need to summarize your data. Pivot table would be simplest but you can not chart directly from the table to xy-scatter.

It maybe possible to use subtotal formula in the table to report summarised values.

[crazytimechris]

Hi Andy,

Thank you for getting back to me.

I did try with a pivot table first but had no luck with showing it graphically. Can you shed some light on the Subtotal formula and how it might help me?

Thanks again!

Chris

[Andy Pope]

can you post example data file to work with

[MrShorty]

You may be interested in this tutorial describing how to make "regular" charts (like XY scatter charts) from a pivot table: http://peltiertech.com/regular-chart...-pivot-tables/