Forum Discussion
Line and Stacked Column Chart - Line labels inside columns
I am using a Line and Stacked Column chart, where I wish to show label values for some of the larger column segments, as well as a total above the column. I have used the same data for my columns as my line, which means that any labels along my line will actually be showing the total of the columns.
I am running into a frustrating problem, however. On the very last column, the line label generates inside of the column, which is confusing at best. Does anyone know how to force the label to go above the column, or why it i generating inside the column in the first place?
The final label, "22", is actually the total value of the column. I wish for this to be above the column like the others, not inside of it.
Hi Anonymous ,
Believe that the best option for this type of visualization is to force the secondary Y-Axis to be much lower than normal this will push your line way up the chart and you will get the labels on the top of your chart.
Scale of secondary Y-axis should be Log maximum 10 minimum 1. Also turn of everything else or make the color as the background in the secondary axis:
First chart is with only a axis second one is witht the configuration I told you.
You can play around with the axis min and max in order to place the labels in the place you want.
1 Reply
- MFelix
Super User
Hi Anonymous ,
Believe that the best option for this type of visualization is to force the secondary Y-Axis to be much lower than normal this will push your line way up the chart and you will get the labels on the top of your chart.
Scale of secondary Y-axis should be Log maximum 10 minimum 1. Also turn of everything else or make the color as the background in the secondary axis:
First chart is with only a axis second one is witht the configuration I told you.
You can play around with the axis min and max in order to place the labels in the place you want.