Jump to content

Aggregates Markers in Scatter Plot

christian PONTHUS

Recommended Posts

I've got a data set (Excel, several 1,000 lines) with a column that contains Projects ID.

I have several lines with identical Projects IDs. I'd like to have 1 single marker per Unique Project ID.

When I select "Marker By = Project ID", I've got as many markers as I have lines for the same Project ID (if A given Project ID exists in 10 lines, I get 10 markers for this Project ID while I'd like to have only one).

How to do

Thanks a lot



Link to comment
Share on other sites

When I start with a regular scatter plot (having cost, revenue and several project ids in my data table) and I change the marker option to project id, the aggregation method automatically switches to Sum() for the x and y axis. And there is only one marker per project id.


Please make sure that you use an appropriate aggregation on your axis.


PS: Next time, please use the comment function to reply. Do not "answer" your own question unless you found the answer yourself ;) 

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...