Forum Discussion
Line and Clustered column chart – two Y axis
Based on my research, currently there is no available way to separate the Line and the column in addition to specify the Start and end of the Y-Axis, , if the data on both Y-Axis stay on the same data type and data range.
It's recommended to add the two shipments both under the column values, so that this would make it much more clear based on the same Y-Axis.
To better use the second Y-axis, it is recommended to add extra data which can’t be rightly calculated by the current Y-Axis.
If you would like to analyze the ratio of shipments, then opening the second Y-Axis and put the ratio value under the line value. Which would make the chart much more efficient.
In addition, check the article below for more reference regarding X-axis and Y-axis:
Tutorial: Customize X-axis and Y-axis properties
Regards,
Charlie Liao
Based on my research, currently there is no available way to separate the Line and the column in addition to specify the Start and end of the Y-Axis, , if the data on both Y-Axis stay on the same data type and data range.
It's recommended to add the two shipments both under the column values, so that this would make it much more clear based on the same Y-Axis.
To better use the second Y-axis, it is recommended to add extra data which can’t be rightly calculated by the current Y-Axis.
If you would like to analyze the ratio of shipments, then opening the second Y-Axis and put the ratio value under the line value. Which would make the chart much more efficient.
In addition, check the article below for more reference regarding X-axis and Y-axis:
Tutorial: Customize X-axis and Y-axis properties
Regards,
Charlie Liao
Thank you so much!
I´ll try another graph
Hugs,
Carol