0
The macro recorder is giving the same code for adding the title for the X and Y axis. On the Y-axis I want 'Age' and on the X-axis 'Year', but after going through the recorder it gives this:
ActiveChart.Axes(xlValue, xlPrimary).AxisTitle.Text = "Age"
ActiveChart.Axes(xlValue, xlPrimary).AxisTitle.Text = "Year"
When the program is run, there is nothing in the X-axis title, and 'Year' in the Y-axis. How do I diversity the codes so that the correct title goes to the correct axis?
~G.
Each axis is a line on a chart that together define its structure and which the data plotted on the graph is measured against. The Y axis is the vertical access, in other words the one that goes up and down. The X access is horizontal and so it goes across a chart. The Y axis is sometimes known as the value axis. Having an axis is common on scatter diagrams or X-Y Charts, bar charts and others. You do not have one on a pie chart.
Add your answer:
Earn +20 pts
The horizontal axis on excel for a chart is called what?
the horizontal axis for chart is called X-axis.
How do you label axes in Microsoft Excel?
after creating your graph go to the layout tab, axis title then choose either horizontal or vertical axis
The horizontal axis for a chart is called the x-axis or the what in Excel?
The independent variable is on the horizontal axis.
Where is the x axis on excel?
The "x-axis" usually refers to the horizontal axis. In Excel, that would be relevant for graphs created with Excel.
Where is the x-axis on Excel bar chart?
It is the horizontal line at the bottom of the chart.
Does excel derives the chart scale based on the values in the worksheet along the vertical axis also called the y-axis or value axis of the chart?
No, it's the horizontal axis (x-axis).
What is the horizontal line of a chart that runs left to right in excel chart?
The horizontal axis is the one going across the bottom of a chart. It can be the X axis in some kinds of charts or the category axis in other kinds of charts.
Does Microsoft Excel automatically select the entries in the topmost row of a chart range as the titles for the horizontal axis of a chart?
no
What are the horizontal and vertical lines in a chart that enable the eye to follow the value on an axis in Excel called?
Grid lines.
Where is the independent variable placed on a line graph?
on the horizontal axis!
What is the x-axis horizontal line?
It is a horizontal axis
What is the y-axis in Excel?
The Y axis is the vertical access, in other words the one that goes up and down. The X access is horizontal and so it goes across a chart. The Y axis is sometimes known as the value axis.
