Showing discrete points in a bar chart

[mrmatt]

Hello,

I have a data set with a bunch of user IDs and values for each ID. I want to create a bar chart like the attached but instead of a count of those user ids, I want to see them each as discrete points on in the bar. Does anyone have any ideas for how to do this?  

[premvihari]

Please provide sample data

[Vegar]

Try to create a bar chart with score and UserId as dimensions  and count(UserID) as your measure. 

In presentation properties choose to present as a stacked graph. 

[mrmatt]

hi @Vegar I actually don't want to count the UserIDs but rather show them as discrete points in the bar chart itself. This is kind of like a scatter shown in a bar chart.

[mrmatt]

@premvihari see attached Excel.

[chriscammers]

It sounds like you want to create a stacked bar chart.

If you add Score and UserID as dimensions and then add Count(UserID) as your measure I think you'll get what you want.

You may need to set the chart to be a stacked bar but with two dimensions it may do it auomatically.