How do I format row height in data tables in excel charts?
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?
Gill-Sans-MT-Left--Arial-Right.jpg
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?
Gill-Sans-MT-Left--Arial-Right.jpg
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Dsastray,
>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.
Patrick
>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.
Patrick
ASKER
Not an insult. T.S. means:
"I've got this problem."
"Here's the solution: Tough sh*t."
"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.
I am now going to unsubscribe from this question as it is serves no purpose whatsoever flogging a dead horse.
If Gill Sans MT won't do it but Arial will do it then that's the answer - use Arial.
Patrick