Creating a Line Graph
- 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,
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
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@clarrock
We can use the Split Function in the Interactive Report Tool.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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,
