Your chart uses text in the source data for these axis labels. Make sure youre working in excel for the web edit mode. Navigate to chart tools layout tab and then click axis titles see screenshot. If you would like to label the primary horizontal. You can insert the horizontal axis label by clicking.Ĭlick anywhere on the chart you want to add axis labels to. Select the data you use and click insert insert line area chart line with markers to select a line chart. To add labels to the axes of a chart in microsoft excel 2007 or 2010 you need to. If you are using excel 20102007 you can insert the axis label into the chart with following steps.Ĭlick primary horizontal axis title or primary vertical axis title.
Select the text in the axis title box and then type an axis title. Select an axis title box.Ĭlick chart axis titles. Navigate to the layout tab in microsoft excels toolbar. To format the title select the text in the title box and then on the home tab under font select the formatting that you want.
How to label axes in excel steps open your excel document. Select the chart that you want to add axis label.Ĭlick anywhere in the chart to show the chart tools on the ribbon.
First off you have to click the chart and click the plus icon on the upper right side. In the labels section click on axis titles. In a chart you create in excel for the web axis labels are shown below the horizontal axis and next to the vertical axis. If you are using microsoft excel 2013 you can rotate the axis labels with following steps. Go to the chart and right click its axis labels you will rotate and select the format axis from the context menu. Actually there is no way that can display text labels in the x axis of scatter chart in excel but we can create a line chart and make it look like a scatter chart.Īxis Labels Numeric Labels Or Both Line Graph Styles To If youre in view mode click edit workbook edit in excel for the web.
highlight the horizontal and vertical lines. 2010 seems to me to be not much more than a web search engine and I am finding it rather unhelpful.If you would only like to add a titlelabel for one axis horizontal or vertical click the right arrow beside axis titles and select which axis you would like to add a titlelabel. Showing data label (value) only on few specific data point (not all data point but show on desired data point). 5.Close the Format Axis window and apply the. 4.Select the text box and enter the same number as the interval unit, leave this at oneand every tick mark will display on the axis, regardless it has a label or not. Is there anything more equivalent to the old version of the help?Īlso the 2002 Excel Help file, while not great, was nice because it was fairly simple and direct explanations generically written by Microsoft. The first axis label will display, then Excel will skip the labels until the number of interval, continues on in that pattern. 2010 seems to me to be not much more than a web search engine and I am finding it rather unhelpful. Any thoughts as to why I can not change the autofit?Īlso the 2002 Excel Help file, while not great, was nice because it was fairly simple and direct explanations generically written by Microsoft. It appears that this problem could be solved by simply changing the selection under "Autofit" from "Allow text to overflow shape" to "Resize shape to fit text", but the "Autofit" section is greyed-out and I can not change the selection. When I do this by right clicking "Format Axis", choosing "Alignment", and changing "Text direction" to "Rotate all text 270 degrees" I run into the problem that half of the date label is cut off and I have to manually resize the chart area. I need to rotate the labels 90 (or 270) degrees so that they are vertical and can be read easily. The problem is that the date labels (that doesn't seem like quite the correct term, I am referring to the text under each tick mark) overlap and cannot be read. I have a chart with dates on the x-axis and values on the y-axis. Just upgraded from Excel 2002 to Excel 2010.