Creating a Line Graph

[clarrock]

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

[Qiu]

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

[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 · Accepted solution]

@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.

[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,