Creating a Line Graph

Hi,

My input data is as below:

Date	Car	EUR	USD
11-04-22	A	200,000,000	(779,964,859)
12-04-22	A	124,377,187	(599,964,859)
13-04-22	A	164,377,187	(579,964,859)

I am trying to creating a line graph, where there are two lines one for EUR and one for USD and the x axis would be the date and the y axis the values.Cant seem to create one using the interactiv chart tool

Please help

Thanks

Developer

Help

Accepted answers

Qiu

@clarrock
Bar Graph can show the value for each data point, therefore, we can create a invisible layer as Bar, then set the color of bar to be same with background, and keep the text for values. Hope this is what you need.

0413-clarrock-r1.yxmd

All comments

Qiu

@clarrock
We can use the Split Function in the Interactive Report Tool.

0413-clarrock.yxmd

clarrock

@Qiu thank you, how do i put the values (rounded to say a mil) on top of the line graph? if this cant be done would it be possbile with a bar chart?

Qiu

0413-clarrock-r1.yxmd

clarrock

@Qiu Hi, my number text shows up as vertical and horizontal, the text position is Auto...but if i change this to outside it works but it removes USD numbers and its not close to the line. Its in the middle of the bar i think,

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703