Forum Discussion
Line chart with different lines per year
Hi Betty888
In order to get to the graph you drew, follow these steps:
1. Choose line chart
2. Put your parametrs like on pict :3. Set up a series labels
It is important to note that such a logical comparison is problematic.
A trend line shows the evolution of an index over time.
It is recommended to make an X-axis as a time axis in order to compare long-term trends between companies.
For each company, there is a representative line.
As you have several lines that collide, it is better to split it into smaller graphs so you don't create cognitive load
Using "small multiples"
As shown in the picture (with setup a right format and design)Link to sampke file with both options here
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Betty888
In order to get to the graph you drew, follow these steps:
1. Choose line chart
2. Put your parametrs like on pict :
3. Set up a series labels
It is important to note that such a logical comparison is problematic.
A trend line shows the evolution of an index over time.
It is recommended to make an X-axis as a time axis in order to compare long-term trends between companies.
For each company, there is a representative line.
As you have several lines that collide, it is better to split it into smaller graphs so you don't create cognitive load
Using "small multiples"
As shown in the picture (with setup a right format and design)
Link to sampke file with both options here
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
hello thank you for explaine how to do it
I have a question if anyone can help me
i have a line chart
I want to calculate the difference between each two points of the same date ?