Can't change x-axis labels

G

Guest

I'm certain this is a rookie question, but I'll be darned if I can figure out
how to change the default labels on a 3-D chart. Here's the story.

I created a 3-D chart with a single series and 5 data points (columns). By
default, Excel placed a numeric value beneath each column. The value that
appears beneath each column is a single digit and is either 1, 2, 3, 4, or 5.
These columns represent the five quarters from 1st quarter 2005 through 1st
quarter 2006.

What I want to do is change the digits to 1st Qtr 2005, 2nd Qtr 2005, etc.

When I brought up the Format Axis window, it provided the means to change
the formatting of the x-axis, but no way to change the digits on the axis.

How do I change the digits to the values I mentioned above??

Any information you can would be greatly appreciated.
 
A

Andy Pope

Hi,

Right click the chartarea and pick Source Data... from the popup menu.
On the Series Tab is an area where you can specify the cells to be used
for the axis labels.

Cheers
Andy
 

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

Top