I don't know how to set the displayed text as horizontal line in the chart.
I don't know how to set the displayed text as horizontal line in the chart. Could you please help me fix it up?
Thanks.
-
Re: I don't know how to set the displayed text as horizontal line in the chart.
Press CTRL + SHIFT
You will get Red Rectangles ..
Now use your mouse to get them at top with horizontal..
It will take some time to adjust them.. Tricky things.. Keep trying..
-
Re: I don't know how to set the displayed text as horizontal line in the chart.
This is indeed very tricky
Step1: Control+Shift undock the Legend from the side and bring it in an area where you can easily adjust it
Now if you directly dock it to top or bottom you will not see all legend because, look at screenshot 1, we have not adjusted width of the legend. So always extend the legend to the full width of the chart.
Now we stretch the legends when it is not docked as below
Now we dock it to the bottom again and Voila!
or at top
-
Re: I don't know how to set the displayed text as horizontal line in the chart.
I did on your instruction above. It's the same in the vertical line.
-
Re: I don't know how to set the displayed text as horizontal line in the chart.
it'll take trial and error
After docking keep on adjusting(increasing / decreasing) the height to show all legends in one line, you might even have to increase the width of the chart itself or reduce the font of the legends to make them fit on the same line
-
Re: I don't know how to set the displayed text as horizontal line in the chart.
go to the properties of the chart and on the General tab - click reset user sizing and reset User docking and try again...it will do it eventually!
-
Re: I don't know how to set the displayed text as horizontal line in the chart.
All I can say is that it took much effort to do that. Well, I have done like what you recommended on trial and error. Then, it is ok.
Thank you very much indeed.
-
-
