Then chose 'Insert' found the chart icon and selected the 'MW' icon - line chart. I charted the data in two columns Date, Value. I got it to work - created a proportionally-spaced chart (dates were spaced correctly - a short gap in dates was closer than a long gap in dates).
24 hr time excel x axis data switch update#
To update a few points for newer versions. (e.g.time) and space the actual data points proportionally along it. Whereas a graph could have the X axis set to some progression of values Possibly there may be an issue of semantics with 'charts and graphs'.Ī chart possibly would space the available data equally along the X axis, Long time gaps now have wide spacing and vice versa) (At this point the data on the graph is equally spaced)Ĭhart Wizard step 3 of 4: Chart Options. > select Y values in data sheet (series in columns)Ĭategory (X) axis labels: select date values in data sheet > chart type Line> chart subtype 4 > Next (basically selecting the 'Category X axis labels' for the X values of dataĪnd setting the radio button to 'Time Scale')Ĭhart Wizard pane Step 1: Standard Types tab To get the data to appear proportionally by date as described, I had to Perhaps you are using a later version where things are different.
I am using the 2003 version where the default appears to be equally Norie - Yes, that's how I want it but it doesn't do that for me. > 2010 then the distance between 1 and 2 isn't the same as that between > eg if date1 is, date2 is and date3 is 08 Sep > When I create a chart with non-equally spaced dates for the X-axis
I don't quite understand what you mean.
0 kommentar(er)
