When using this solution, ensure the numeric values always have the same number of characters, otherwise the X axis sort will be incorrect, as it is sorted according to the string and not sorted by the number. The height of the bar shows the number of times that. I would like to highlight or change the font color of a specific month on the x-axis. The bars: This parameter has a height and width. Format x-axis labels in Excel 2013 I have a simple line graph with numbers on the y-axis and months on the x-axis. On the Format tab, in the Current Selection group, click Format Selection. On the Format tab, in the Current Selection group, click the arrow in the Chart Elements box, and then click the data series that you want to plot along a secondary vertical axis. Y-axis: The Y-axis is the scale that shows the number of times that the values occurred within the intervals set corresponds to the X-axis. This displays the Chart Tools, adding the Design, Layout, and Format tabs.

For a sample report demonstrating this solution, download the report: Chart X Axis Without Decimals.rpt, located in the Attachments section below. X-axis: The X-axis is the grouped interval that shows the scale of values in which the measurements lie.

Now, the chart will display the X axis numeric value with no decimals. Edit the chart, and replace the database field used for the X axis of the chart by the formula.ģ.1 Right click on the chart, and select 'Chart Expert'ģ.2 In the 'Chart Expert' window, under the tab 'Data', remove the field used under 'On Change of', and replace it with the formula created in step 2.Double click on the labels for the Y axis, and on the Alignment tab, select Left. After running the macro, all that is required is to position the labels. Create a formula that converts the numeric value used on the X axis of the chart to a text without decimals. Add the X axis helper series as above (copy the range, select the chart, Edit > Paste Special > New Series) and run this for the second extra series (the X axis): AttachLabelsToPoints 0, 3, 2.In Crystal Reports deisgner, open the report on which you have the chart.

To ensure there is no decimals displayed on the x axis of the chart, convert the numeric values to text, and use the converted value for the x axis on the chart.

How to format x axis in excel 2013