Change a chart category axis

J

James

The numbers I want on my x-axis should be separated equally and going from
left to right I want listed "100 50 30 16 8 4 3/8 3/4 1.5". Is there
a way to add a secondary x-axis or display these numbers across the chart
evenly spaced? Is there a way to change labels on the x-axis while keeping
the same value? My chart looks like I want it, but the numbers across the
x-axis are "1 2 3 4 5 ... 11".

I saw a help topic saying to click "Format" and then I can specify frequency
on the scale tab, but there is nothing about frequency on the scale tab.

Any help?
 
A

Andy Pope

Hi James,

If the chart type has a category x axis then you just need to the range
to the correct cells.
Right click on the chart and pick Source data. On the Series tab of the
dialog is where the category range is specified.

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