Excel Axis Does Not Match Data. The next column is 'amount' which. If you see numbers there instead of the desired text, click edit. edit the chart data and check the entries for horizontal (category) axis labels. In chart tools, select the layout tab. try changing the chart type to a clustered column chart and see if that fixes your first problem. 1 is 'code' which has the following values: the problem is probably due to excel automatically setting your horizontal axis. if i understand your problem correctly, it looks like you have data at an irregular interval, and you want to plot it as xy data but have the x axis grid lines. the system is assigning the axis values based upon the data selected, yet the values are incorrect on the axis. As for the series order, select. i'm setting up a sheet to automatically plot data (2 data columns with a primary and secondary y axis and common x axis data). i have 2 columns in my excel file.
from www.youtube.com
i have 2 columns in my excel file. if i understand your problem correctly, it looks like you have data at an irregular interval, and you want to plot it as xy data but have the x axis grid lines. the problem is probably due to excel automatically setting your horizontal axis. the system is assigning the axis values based upon the data selected, yet the values are incorrect on the axis. As for the series order, select. edit the chart data and check the entries for horizontal (category) axis labels. i'm setting up a sheet to automatically plot data (2 data columns with a primary and secondary y axis and common x axis data). The next column is 'amount' which. 1 is 'code' which has the following values: try changing the chart type to a clustered column chart and see if that fixes your first problem.
Change an Axis label on a graph Excel YouTube
Excel Axis Does Not Match Data 1 is 'code' which has the following values: In chart tools, select the layout tab. the problem is probably due to excel automatically setting your horizontal axis. i have 2 columns in my excel file. The next column is 'amount' which. 1 is 'code' which has the following values: try changing the chart type to a clustered column chart and see if that fixes your first problem. the system is assigning the axis values based upon the data selected, yet the values are incorrect on the axis. If you see numbers there instead of the desired text, click edit. if i understand your problem correctly, it looks like you have data at an irregular interval, and you want to plot it as xy data but have the x axis grid lines. As for the series order, select. edit the chart data and check the entries for horizontal (category) axis labels. i'm setting up a sheet to automatically plot data (2 data columns with a primary and secondary y axis and common x axis data).