trouble with chart; overlapping axis title and axis label

[olitvinov]

I have a horizontal bars chart.

How to make 'axis title' ( on my vertical axis) not to overlap with 'axis labels' (on my vertical axis)?



Details: when I modify chart formatting while in preview, those two items are becoming separate.

but when I modify chart formatting while in design mode, they are drawn in the same area. Making vertical and horizontal texts being on top of each other.

I wish I could attach a picture of this chart.



Any thoughts?

 

[Dimst]

olitvinov,

Try using rightmouse click on chart, then Format Chart and then Grid or General; there are some possibilities to work with the place where the titles have to come, or where the legend have to be placed.

D

 

[olitvinov]

The truth is that the chart is not completely configurable.
Nevertheless, I solved my problem to the extend that was needed.

Here how you do it. (everything is in the designer mode as opposed to preiview)
You can click on the vertical bar and move it to the right. After that select vertical axis title and move it to the left. Now you have made some spacing for title labels.
But there are problems. If you change something in the chart afterwords (like I had changed bar options on the chart) the axis position will fall back where it started (overlaping 'axis title' with 'axis labels'). So, in that case do you settings (like bar chart formatting) first, then move axis away from axis title.

Another caveat, don't make changes in the preview mode on charts. They are futile becase it only lasts to the next refresh. Find the same properties and settings in design mode and do it there. At least know that changes in preview mode won't last.

Hope this will help somebody,
Oleg