How to generate a continuous time series scatter chart with the entire date range shown on the plot?

[pingster]

Hi all,

I am trying to generate a scatter chart of a set of time-series data. Basically I need it to be exactly like the line chart, but with markers instead of lines. Ideally it would like the following chart, which was produced in Excel instantly. I have tried:

• scatter chart, but x-axis was "Categorical" instead of "Continuous" hence failing to shower the time-series with the correct scale/spacing. There is scroll bar to scroll across the chart, but that was a month's worth of data and I have years.
• scatter chart with dates indexed to integers, but it only shows a level of the date hierarchy i.e. either day, month or year only. I need the entire time series to be shown.
• line chart with markers and no line, but x-axis was "Categorical" instead of "Continuous" hence failing to show the time-series with the correct scale/spacing

Surely this has come up before but I have not been able to find a post that share the exact same problem. 

Is there a way to generate a time-series scatter chart as per below, whether it is using existing or custom visualisation?

Much appreciated!!

[Anonymous]

Was a solution ever found? I am having the same issue...

[pingster]

Not really. I just made do using line chart with markers line width 0. If the date column is formatted correctly then I get a Continuous x-axis. However the downside is that if there were more than one data point in a day, they will be aggregated. In most cases I can live with an average. In saying that, I could probably add hh:mm:ss in the Date hierarchy to show all data points for some of my datasets but that is a bit of an overkill.

Alternatively, use Python or R visuals.

Hope that helps!

[v-shex-msft]

HI @pingster ,

If you mean create a visual similar as you shared, you can create a scatter chart with time field as x axis, amount field as y axis, category to legend, it will display the graph you wanted.

If you mean create scatter chart display points as line, I think it is hard to achieve.

Regards,

Xiaoxin Sheng

[pingster]

Hi @v-shex-msft,

Thanks for your reply. I have tried that too. Unfortunately as you can see in your chart, it assumes equal spacing between every data point. This is technically incorrect and I need to be able to show the true scale i.e. equal spacing. Also as I mentioned in my post, there is scroll bar to scroll across the chart which I need to avoid because I want to visualise years of data.

Is there another way to achieve this?

Regards,

Shi Ping

[v-shex-msft]

HI @pingster,

Maybe you can try to use R visuals to manually plot similar scatter chart based on your records.

Scatter Plots - R Base Graphs 

Regards,

Xiaoxin Sheng

[MvdVecht]

I am struggling with the same issue - have you found a way to create the plot ?