Re: how to change the value of x -axis on the excel graph That was for Excel 2000 or 2003, For 2007, 2010, When you click on the chart, 3 new tabs are added to your Ribbon under the topic of 'Chart Tools'.
Posted:, 12:38 PM On 2/11/08 7:54 PM, in article 9absDaxw, '[email protected]' wrote: This 'feature' of Excel 2008 is driving me nuts. I wasted a half hour today trying to figure out how to add labels to the X axis.
I finally fired up my ancient Windows laptop, added labels with Excel 2002, and then re-opened the spreadsheet on my Mac. I'm not quite clear on the 'solution' which Ben describes. In my case, my series labels are in column A, and data begins in column B. My X axis labels are all in a row across the top of the spreadhseet, beginning in column B. The labels are numbers (1992 through 2008). Excel picked up the series labels automatically, but no matter how I selected the data range, the X axis labels never appeared — all I got was numbers 1, 2, 3, etc.
Is there some magic technique for selecting the data range that I somehow overlooked? I can't help but wonder why the Mac BU dropped the feature from Excel 2008 to specify a range for 'Category (X) axis labels.' However they intend users to select/add X axis labels in the new version is not at all obvious. The feature was not dropped. Select the chart, then select chart options in the formatting palette. Select the axis and then enter the title.
Bob Greenblatt MVP, Macintosh bobgreenblattATmsnDOTcom. Posted:, 06:28 PM Hi Bob: For some reason, I'm not quite understanding your instructions. Under 'Chart Options,' I only see the option of adding a title to the 'Horizontal (Category) Axis.' I can't find any drop-down menu or otherwise where I can specify the labels for the axis. I want to assign a range of cells so that they appear as the labels along the X axis (I have a dozen or so columns in my chart, and at the bottom of each column I want the value in the corresponding cell from within the specified range to appear). In previous versions of Excel, there was the option to specify the range for 'Category (X) axis labels.'
I can't find anything similar in Excel 2008. I had expected to find it in the 'Select Data Source' pop-up, which is activated by clicking 'Edit.' Under 'Chart Data.' That's where it used to live in previous versions. Thanks for your help! Posted:, 07:01 PM On 2/12/08 1:28 PM, in article 9absDaxw, '[email protected]' wrote: Hi Bob: For some reason, I'm not quite understanding your instructions. Under 'Chart Options,' I only see the option of adding a title to the 'Horizontal (Category) Axis.'
I can't find any drop-down menu or otherwise where I can specify the labels for the axis. Look at the little triangle next to title. Click it and you will have options for Chart title and each axis. To link the title to a cell, add the axis title as described above.
Then enter a formula in the formula bar to link to the range. I want to assign a range of cells so that they appear as the labels along the X axis (I have a dozen or so columns in my chart, and at the bottom of each column I want the value in the corresponding cell from within the specified range to appear). You may have to change the chart type. Or reselect the range and draw the chart again. In previous versions of Excel, there was the option to specify the range for 'Category (X) axis labels.'
I can't find anything similar in Excel 2008. I had expected to find it in the 'Select Data Source' pop-up, which is activated by clicking 'Edit.' Under 'Chart Data.' That's where it used to live in previous versions. If you are still having trouble, send me the workbook and an explanation of what you want. Thanks for your help!
![]()
- Bob Greenblatt MVP, Macintosh bobgreenblattATmsnDOTcom. Posted:, 11:10 PM Okay, here's how to do it (explanation courtesy of Bob Greenblatt — there's no way I could have figured this out on my own!): To specify a range of cells as the labels on the X axis, click on one of the data series in the chart (for example, click on one of the colours in a bar chart). When you do, you will see a range appear in the floating formula bar. In my case, the range in the formula bar was: =SERIES(Summary!$A$5,Summary!$B$5:$R$5,3) The space between the two commas is where the X axis labels are specified. In my case, for whatever reason, Excel didn't pick up the labels when I created the chart.
I added the range of cells containing the X axis labels (cells B3 through R3) like so: =SERIES(Summary!$A$5,Summary!$B$3:$R$3,Summary!$B$ 5:$R$5,3) Problem solved! The challenge, of course, will be to remember how to do this in a few weeks. I can't believe that MS figured that was easier than the old way (where there was a clearly-labelled field in which a user could specify the range). Posted:, 03:32 PM Okay, so I was having the same problem as well.
As a new Mac user I was completely lost in Excel, but I am now learning its just the new version of excel that was throwing me for a loop. Even after reading through how to fix this problem my co worker finally found the toolbar that assists you to label the title, x axis and y axis!! Labeling the Title, X axis, and Y axis: Go to the main toolbar in your worksheet and file the icon 'TOOLBOX', once you click on toolbox the 'FORMATTING PALETTE' will appear.
MAKE SURE YOU HAVE YOUR GRAPH SELECTED.then click on 'CHART OPTIONS'. Right under chart options you will see 'TITLES' you can then select either chart title, x axis or y axis, then just type into the line below and label away! After you label them you can then go back in and change the title like in the old format by just double clicking on it!! SImple as can be NOW!!!
Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |