Truncated X Axis Labels in Line Chart

  • Thread starter Thread starter Nick
  • Start date Start date
N

Nick

I have a worksheet made up of 12 sheets of charts and 2
sheets of data.

6 of the charts read data from sheet 1.

6 of the charts read data from sheet 2.

For some reason, all the charts related to sheet 1 display
the complete x axis label eg. 2x12, 2x24, 2x32 etc.

All the charts related to sheet 2 truncate the label. For
example:

2x12 displays as 2x1
2x24 displays as 2x2
2x32 displays as 2x3

I have checked my formats and they are the same between
the two data sheets.

Can anyone tell me how to resolve this?

Thanks
 
Would smaller font help? I've had truncated labels when I have too many series to
show on the chart. Sometimes smaller fonts helped me.
Rita
 
Back
Top