Can I change the height of a chart's data table so that the height of the rows is smaller

I have a chart in Excel that I need to copy into PowerPoint, but it's too tall if I copy and paste it as a chart. I can paste it into PPT as a picture and make it shorter but then the text gets all scrunched up. With a font size of 7 for the data table there's enough space within each data point "cell" to make the rows shorter and still leave room for the size 7 number to be legible, without making the font smaller.

Two questions: 1) does this make sense?   2) is it possible to do?

John CarneyReliability Business Tools Analyst IIAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Katie PierceCommented:
So you're changing the font size of each axis?  That should work.  If you need to increase the font size to make it legible, you can always change the Major Units of the axis so that fewer data points appear, and the larger font fits.
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Hello John,

yes, it does make sense, but, no, unfortunately, a data table cannot be resized. It is one of those chart elements that just can't be resized.

Don't shoot the messenger.

cheers, teylyn
Justin AlvarezAccount ManagerCommented:
I guess it depends on what you mean by chart. If you are strictly copying a collection of cells, then you can adjust the row height and font size.

If you used the data table to generate a chart (e.g., bar chart, pie chart, scatter plot), then it might be a bit trickier.

Do you have a sample we can look at?
OWASP: Avoiding Hacker Tricks

Learn to build secure applications from the mindset of the hacker and avoid being exploited.

Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Justin Alvarez, John is referring to the data table that can be turned on in an Excel chart, not to a range of cells in a worksheet. Are you familiar with that feature at all?
I found a way to do this. Well, not exactly but I did find that if the chart is in PowerPoint, I can change the paragraph line spacing on the data table, which does make it less tall.

Select the data table and go to the Home tab in PPT. Click the dialog launcher (the little arrow in the lower right corner) in the Paragraph group.

Change Line Spacing from Single to Multiple, then input .7 to make the line space 7 tenths of a single line. (Much smaller than that, and the numbers will be cut off.) The data table is based on a single line by default, so changing it to a partial line will shorten it.

Now if I could only figure out how to format line spacing in Excel!
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Echo, you can't because Excel does not have such advanced typesetting options. Talk about consistency. Just look at what we have to deal with in Excel styles. Shudder.

Good tip for the PowerPoint side of things!!

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
John CarneyReliability Business Tools Analyst IIAuthor Commented:
Thanks for getting me out of denial!
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.