Scatter plot in Excel using time data for x-y scatter plot graph without converting to data series
excel, excel-2010, scatter-plot
Solution
Make sure Excel knows the times are really times, and not just text that looks to you and me like times.
Insert a row above the two columns of data. Keep the cell above the times (X values) blank, put a label above the Y values. Select this range including the header row, insert an XY chart.
Problem
I have data for the x and y coordinates that are based on time ("hh:mm:ss") for an x y scatterplot for excel. Although I have put the x-axis data and y-axis data in adjacent columns and have highlighted them both when choosing the scatterplot, the excel continues to recognize the data not as x and y coordinates but two independent data series. How can I make the excel scatter plot program recognize the data as x axis and y-axis data points and not data series (independent variables)?