If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Change a chart category axis
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? |
#2
|
|||
|
|||
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 James wrote: 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? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Chart menu visible property | Sandy V | Charts and Charting | 8 | May 17th, 2004 01:39 PM |
add vertical line to floating bar chart, still trying | bbxrider | Charts and Charting | 6 | January 27th, 2004 11:42 PM |
Category Axis Area in Bar Chart Cuts Words Apart on Wordwrap | Viper | Charts and Charting | 1 | September 28th, 2003 02:31 AM |