How to tilt numbers beneath the chart

**adaa89** · 05-11-2013, 06:57 AM

I've got a problem with tilting the numbers in the table beneath my chart so they would fit to the paper. Picture attached.
Przechwytywanie.JPG

**XOR LX** · 05-11-2013, 07:46 AM

Why can't you just change the Font Size for the horizontal axis?

**adaa89** · 05-11-2013, 10:47 AM

Because then I have to put there hours like: 10:50 - 11:30 and it would not fit.
So is it possible?

**XOR LX** · 05-11-2013, 10:52 AM

Sorry. Not sure I understand. Can you post a sample of your workbook and indicate precisely what you wish to see?

**adaa89** · 05-11-2013, 11:41 AM

I would like it to look like in this pic (attached) however here I simply pasted a table as an image. I can't change the font cause later on I will fill the table with more data and it wouldn't fit anyway. Also it has to be readable.

**XOR LX** · 05-11-2013, 12:00 PM

Ah, I see. Unfortunately - as far as I know, but perhaps with VBA? - there is no way to change the text direction in a Chart Data Table. If you can't abbreviate the entries and don't want to reduce the font size, perhaps you'll have to resign yourself to presenting the data and chart separately.

Sorry I couldn't help.

**adaa89** · 05-11-2013, 12:07 PM

Ok, thank you very much. I think I will do it separately.

**Andy Pope** · 05-12-2013, 07:45 AM

The formatting of chart data table is very limited.
You might be able to display the information in the chart by using datalabels.

Better to use cells on a worksheet aligned to the chart to present the information.