Macro to change all x- and y-axis in every chart in a worksheet back to auto Hi, I have a worksheet that has several graphs and I've set up a a worksheet_change function to change x and y axis values according to user input. Original Title: 'Excel Graph: Axis Scale' How in the world do I change the scale on a graph in Excel 2011 for Mac?! I'm trying to plot tooth wear data (x axis) and frequency (y axis) in a bar graph/histogram, and I'm having a heck of a time. ![]() Note: The following procedure applies to Office 2013 and later versions. • In a chart, click to select the category axis that you want to change, or do the following to select the axis from a list of chart elements: • Click anywhere in the chart. This displays the Chart Tools, adding the Design and Format tabs. • On the Format tab, in the Current Selection group, click the arrow in the box at the top, and then click Horizontal (Category) Axis. • On the Format tab, in the Current Selection group, click Format Selection. • In the Format Axis pane, do any of the following. Important: The following scaling options are available only when a category axis is selected. • To reverse the order of categories, expand Axis Options, and then select the Categories in reverse order check box. • To change the axis type to a text or date axis, expand Axis Options, and then under Axis Type, select Text axis or Date axis. Text and data points are evenly spaced on a text axis. A date axis displays dates in chronological order at set intervals or base units, such as the number of days, months or years, even if the dates on the worksheet are not in order or in the same base units. Note: Selected by default, Automatically select based on data determines the axis type that makes the most sense for your type of data. • To change the point where you want the vertical (value) axis to cross the horizontal (category) axis, expand Axis Options, and then under Vertical axis crosses, select At category number and type the number that you want in the text box, or select At maximum category to specify that the vertical (value) axis cross the horizontal (category) axis after the last category on the x-axis. Photoshop for mac with toch bar. • To change the interval between tick marks, expand Tick Marks, and then in the Interval between tick marks box, type the number that you want. • In a chart, click the category axis that you want to change, or do the following to select the axis from a list of chart elements: • Click anywhere in the chart. This displays the Chart Tools, adding the Design, Layout, and Format tabs. • On the Format tab, in the Current Selection group, click the arrow next to the Chart Elements box, and then click Horizontal (Category) Axis. • On the Format tab, in the Current Selection group, click Format Selection. • In the Format Axis dialog box, under Axis Options, do one or more of the following. Tip: Type a smaller number to place the labels closer to the axis. Type a larger number if you want more distance between the label and the axis. • To reverse the order of categories, select the Categories in reverse order check box. • To change the axis type to a text or date axis, under Axis Type, click Text axis or Date axis. Text and data points are evenly spaced on a text axis. A date axis displays dates in chronological order at set intervals or base units, such as the number of days, months or years, even if the dates on the worksheet are not in order or in the same base units. Note: Selected by default, Automatically select based on data determines the axis type that makes the most sense for your type of data. • To change the placement of the axis tick marks and labels, select any of the options that you want in the Major tick mark type, Minor tick mark type, and Axis labels boxes. • To change the point where you want the vertical (value) axis to cross the horizontal (category) axis, under Vertical axis crosses, click At category number, and then type the number that you want in the text box, or click At maximum category to specify that the vertical (value) axis cross the horizontal (category) axis after the last category on the x-axis. By default, the minimum and maximum scale values of each axis in a chart are calculated automatically. However, you can customize the scale to better meet your needs. For example, if all the data points in your data table are between 60 and 90, you might want the value (y) axis to have a range of 50 to 100 instead of 0 to 100.
0 Comments
Leave a Reply. |