Continuous Interactive Chart
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
- Labels:
- Reporting
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@NikBarter, give this a try it seems to work fine for me.
Attaching the workflow along.
Thanks!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Yes tried doubles earlier, but didn't work.
However, deleting the Interactive Chart Tool, then adding it back in makes it work - thanks.
