After that, fix up a little your x axis properties, so the year shows every year, and not every two or so. After that go to select data, and select x and y values by hand from series 1. What kind of graph do you want? To get this, choose your chart as a linear type xy scatter group. How the heck do you do this? I don't understand quite. When I select my data, Excel wants to map both at the same time, rather than plotting each pair as a point on the graph. In the chart, I want year to be the X axis and the value to be the Y axis, and have a single line mapping the change in value over years. My data is a very simple one: Value Year - 1 13 1912 etc. I'm struggling while trying to plot simple data into a simple chart in Excel 2010 beta.
Right-click the scatter chart and click Select Data in the context menu.Ĭhange how rows and columns of data are plotted in a chart On the left, there will be the different columns of y values. Then select the number format you want to apply in the Category drop-down list box followed by the appropriate options associated with that format. In this step, I have no idea to make it automatically but change the range on your own.
Selecting this option forces the chart to assume your categories are dates, and will arrange the information in chronological order, regardless of the order that it appears in your source data. ※ Download: ?dl&keyword=excel+switch+x+and+y+axis&source=
24 HR TIME EXCEL X AXIS DATA SWITCH HOW TO
How to Format the X and Y Axis Values on Charts in Excel 2013
0 kommentar(er)
