CODEWITHSUNDEEP
excelexcel-2010scatter-plot
Exit Exit Pandora
Exit Exit Pandora

Reputation: 51

Scatter plot in Excel using time data for x-y scatter plot graph without converting to data series

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)?

Upvotes: 5

Views: 45531

Answers (2)

Jon Peltier
Jon Peltier

Reputation: 6063

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.

Upvotes: 5

rcagantas
rcagantas

Reputation: 21

Change the cell format of the x-axis data to a NUMBER or TEXT before making the chart. When the chart is rendered, change the display formatting of the x-axis back to date/time.

Upvotes: 1

Related Questions