Continuous Interactive Chart

[NikBarter]

Hi

How can I set the chart axis of an interactive chart to be continuous, i.e. even gaps between the gridlines.

All I am getting is a straight line (when it should have a nice curve to it). I've tried setting the "Bank" data as fixed decimal and as double but still get the same problem.

Can anyone help (data below)

Period Bank
2022-06-30 48085.45
2022-07-31 415735.07
2022-08-31 1066997.36
2022-09-30 2001872.31
2022-10-31 3220359.92
2022-11-30 4722460.18
2022-12-31 6508173.10
2023-01-31 8577498.68
2023-02-28 10930436.92
2023-03-31 13566987.82
2023-04-30 16487151.38
2023-05-31 19690927.60
2023-06-30 23178316.48

[IraWatt]

Hey @NikBarter,

Make sure your numeric data is not set to string (text data type). Use a Select Tool and set the numbers column to double:

[grazitti_sapna]

@NikBarter, give this a try it seems to work fine for me.

Attaching the workflow along.

Thanks!

[OllieClarke · Accepted solution]

Hey @NikBarter as @IraWatt said, you need to make your data type a double. However, I have had situations when the interactive chart tool didn't recognise such a change if I made it after I'd configured the tool, so you might need to bring in a fresh interactive chart tool to get the chart you want.

Hope that helps,

Ollie

[NikBarter]

Yes tried doubles earlier, but didn't work.

However, deleting the Interactive Chart Tool, then adding it back in makes it work - thanks.