We help IT Professionals succeed at work.

How do I format row height in data tables in excel charts?

Last Modified: 2012-05-08
Right now I have a data table in a chart that has excessively tall rows, making the data table cells feel excessively spacious, as well as increasing the overall height of the data table.

The desired font inside the table is 10pt Gill Sans MT.

If I copy the table and change the font to 10pt Arial, the overall height of the data chart is reduced - the rows are spaced much closer together - despite having larger text.

Is this Excel's interpretation of some unchangeable property of the font (ie default leading)? Is there a way to get around this?

My ideal solution involves narrowly spaced rows with Gill Sans MT font. Is this possible?

Watch Question


If Gill Sans MT won't do it but Arial will do it then that's the answer - use Arial.

This one is on us!
(Get your first solution completely free - no credit card required)

>I have to say, I did not find your answer helpful. It seems like the EE equivalent of "T.S." The fact that it decreases the likelihood of other experts responding with useful answers doesn't thrill me, either.

If you think it's going to help there's nothing to stop you asking the same question again - it's not a lot of effort and doesn't cost you more. Meantime I have no idea what T.S. means - if it's an insult then you have picked the wrong forum for that, apart from which it has completely failed to register with me.

Not all the answers you will receive in Experts Exchange are gems - that's just the way it is. You've been a member long enough to know that and not to complain about it.



Not an insult. T.S. means:

"I've got this problem."
"Here's the solution: Tough sh*t."
Silly comment from you. If you believe there is a better answer available from someone, then ask the question again. Perhaps you will get a better answer.

I am now going to unsubscribe from this question as it is serves no purpose whatsoever flogging a dead horse.

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.


Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.