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?
Thanks,
John
Two questions: 1) does this make sense? 2) is it possible to do?
Thanks,
John
Katie Pierce
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.
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
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
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?
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?
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!
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!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for getting me out of denial!