Hi,

I have came across a requirement to display 4 charts in a single screen in equal quadrants.

There is a problem to displaying long y axis labels in small space which is by default looking like below

with sample data:

Where Y axis labels taking considerable space instead that should be utilized for data trend.

Here is the trick to display above chart in little good way to utilize the data to show data trend…like below

There is little twist in data, add one dummy row .

Keep values in dummy row very low with respect to actual values.

Add Dummy Series

Now go to “Appearance” tab -> Select “Data Labels” and for Dummy series select “Category Label” only.

for others select ” Value” position “Outside end”.

That’s all about little trick to get above bar chart with long labels.

Thanks…

Pankaj Sharma

To report this post you need to login first.

5 Comments

You must be Logged on to comment or reply to a post.

  1. JASH JACOB

    This sir, is pure genius. I had faced this issue and left it as is for then. But I can surely use this if it comes up in future.

    (0) 

Leave a Reply