Change a chart category axis

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
Back
Top