My Xy Scatter Chart Doesnt Use My. The position of each dot on the horizontal and vertical axis indicates values for an individual data point. The data type of column TIME in the table and X-Axis is changed to TIME.
Is there any way I can insert the value by myself. When I make a scatter of this however Excel uses the numbers 1-20 as x-axis. The Chart Data tab of the Format Object dialog will appear.
The data type of column TIME in the table and X-Axis is changed to TIME.
My data for frequency x-axis ranging from 0 to 20kHz. My horizontal axis is both a genuine time gestational age in weeks and a set of categories since I have a value for each possible gestational age from 14-39 It also seems odd that Im force dto use the Sum and then ralter the legend accordingly. However only date is considered and The time axis is ignored in the graph and is always considered as 1200. For example right-click the x-axis numbers 0 to 4 click Format Axis and change Minimum and Maximum by clicking Fixed instead of Auto and filling in the values that you want perhaps 15 and 35.