WebFeb 9, 2015 · You have to use appropriate references. For example (Untested)Sub ChangeAxisScale() Dim wsChart As Chart Dim wsInput As Worksheet '~~> Change the below as applicable Set wsChart = Chart1 '<~~ Code name of the chart sheet Set wsInput = ThisWorkbook.Sheets("Sheet1") '<~~ Name of sheet with data With wsChart With … WebClick anywhere in the chart for which you want to display or hide axes. On the Design tab, click the down arrow next to Add chart elements, and then hover over Axes in the …
dynamic x-axis for an excel chart - Microsoft Community
WebChange the scale of the horizontal (category) axis in a chart. Click anywhere in the chart. On the Format tab, in the Current Selection group, click the arrow in the box at the top, … WebJul 16, 2010 · Hello, I have a weird graphing problem. I have about 30+ graphs in a spreadsheet, where they all reference a range of data. The data is a bit complex, as it is filled with #N/A's for graphing purposes (so dynamic graphs were too complicated). My code changes the range of the data available... food banks in leith edinburgh
excel - Changing x-axis of a ChartObject in VBA - Stack …
WebSep 21, 2024 · But for such, you can't have multiple values in same X value. You may: consider using transposed data: if color grouping required, using a serie by each point and then format every serie as required: EDIT: Code for 2nd option: Following code will produce desired chart. Note chart isn't interactive, ie, changing values in spreadsheet won't ... WebMay 5, 2024 · Microsoft Excel 97 through Excel 2003. On the Insert menu, click Chart to start the Chart Wizard. Click a chart type, and then click Next. Click the Series tab. In the Series list, click Sales. In the Category (X) axis labels box, replace the cell reference with the defined name Date. For example, the formula might be similar to the following ... WebApr 13, 2024 · Excel 2024 - Cannot Edit Horizontal Axis Labels. Hello, I'm having some problems in trying to label the x axis on a table. The chart displayed the correct points needed. However, the axes displayed is the number of data points (which is about 1500 points) instead of the chosen x axis data, which is supposed to be in the range of 0-30 … food banks in leyland