CODEWITHSUNDEEP
excelchartstimeserieschart
user3198755
user3198755

Reputation: 477

Plot Time Date Chart On Excel

I have an excel sheet with the following columns

Date Time Value

I want to plot a chart with Time on X-Axis, Value on Y-Axis and Date as a line on the chart. How can I do that?

Upvotes: 0

Views: 1363

Answers (1)

L.Dutch
L.Dutch

Reputation: 966

This is how you can do:

I refer to this data for example enter image description here

  1. Select the (time,value) pairs for the 16th, insert a scatter plot. You will then get this enter image description here
  2. now right click on the chart, choose Select data and Add. Select the pairs for the 17th on the appropriate X and Y field. Edit also the label. You will now get this enter image description here
  3. Repeat step 2 for the 18th, you'll get this enter image description here

Upvotes: 1

Related Questions