Truncated X Axis Labels in Line Chart

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
 
R

Rita Palazzi

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

One extra x axis item that wont go away - can anyone help? 3
change chart primary horizontal axis label or name 1
Labeling on independently stacked line chart 0
Adding a line to a population bar chart 0
Line Chart - Problems with labeling X-Axis 3
comparison line graph help needed 8
X-Axis Labels 1
Excel 2010 - Line Chart with Mulitiple Data Sets 1

Top