Scatter chart with days/date on x-axis

[Glenn_Renwick]

Hi,

I would like to create a bubble chart that will cycle through dimensions.

I want to have:

the values on the Y-Axis

the bubble size the sum of values

Days in the X-axis

It seems that having the day number on the x-axis causes a problem with this type of request.

I've uploaded the application but you can see that some values do not appear in the graph but they have multiple values for a dimension on the same day.

Any suggestions to fix this issue?

[jagan]

Hi Glenn,

Scatter chart is the right pick for your requirement, generally in Scatter chart both x and y axis should be expressions, but day is a dimension.  Instead of using Scatter you can go for either Bar or Line chart.  You can analyse based on the bar height in the bar chart and the position of line in y axis.

Hope this help you.

Regards,

Jagan.