When you lot create a chart, Microsoft Role Excel determines the axis on which the information series are plotted, based on the number of worksheet rows and columns that are included in the chart, placing the larger number on the horizontal axis. How Excel determines how information is plotted in a nautical chart How Excel determines how information is plotted in a chart For more information virtually how to create a chart, come across Create a chart. Important:To complete this procedure, you must have an existing chart. For example, if rows of data are displayed on the horizontal (category) axis, but you want them to be displayed on the vertical (value) axis instead, yous tin can switch rows to columns and then that the data is displayed in the chart the fashion that yous want.
If a chart that you lot create does non display the worksheet information on the axis that you want, you lot can quickly change the way that information is plotted. Excel for Microsoft 365 Excel 2021 Excel 2019 Excel 2016 Excel 2013 Excel 2010 Excel 2007 More.Less
0 kommentar(er)
