can't make graph from data

D

dmheller

Board Regular
Joined
May 26, 2017
Messages
156
Office Version
  1. 365
I have this data, Time is in column B and it is a date starting at B2.
I made some dynamic names
Time
=Sheet2!$B$1:INDEX(Sheet2!$B:$B,COUNT(Sheet2!$B:$B)+1)
Temp
=Sheet2!$C$1:INDEX(Sheet2!$C:$C,COUNT(Sheet2!$C:$C)+1)

I go to make an xy scatter using the XY scatter plot and it send this. not even close.

1669677074995.png

I try to make a graph using the names i created, still nothing. What is going on with the graphing of this data?

TimeTemperatureDew PointHumidityWindSpeedGustPressurePrecip. Rate.Precip. Accum.UVSolar
9/1/22 1:04 AM​
53.8 °F52.0 °F52.096 %SW0.0 mph0.0 mph29.58 in0.00 in0.00 inw/m²
9/1/22 5:04 AM​
57.4 °F56.0 °F56.099 %SSW0.0 mph0.3 mph29.59 in0.00 in0.00 inw/m²
9/1/22 9:04 AM​
58.6 °F57.4 °F57.496 %NNE0.8 mph1.2 mph29.62 in0.00 in0.00 inw/m²
9/1/22 1:04 PM​
72.3 °F61.6 °F61.670 %4.1 mph5.3 mph29.58 in0.00 in0.00 inw/m²
9/1/22 5:04 PM​
86.4 °F57.6 °F57.638 %NNE2.3 mph3.1 mph29.49 in0.00 in0.00 inw/m²
9/1/22 9:04 PM​
64.0 °F58.0 °F58.081 %WNW0.0 mph0.0 mph29.45 in0.00 in0.00 inw/m²
9/2/22 1:04 AM​
62.4 °F60.0 °F60.092 %NE3.4 mph3.8 mph29.44 in0.00 in0.00 in
0​
w/m²
9/2/22 5:04 AM​
53.7 °F52.0 °F52.097 %East0.0 mph0.0 mph29.44 in0.00 in0.00 in
0​
w/m²
9/2/22 9:04 AM​
57.8 °F56.0 °F56.098 %North0.2 mph0.2 mph29.45 in0.00 in0.00 in
0​
w/m²
9/2/22 1:04 PM​
78.1 °F65.6 °F65.665 %NE4.7 mph5.4 mph29.41 in0.00 in0.00 in
0​
w/m²
9/2/22 5:04 PM​
85.3 °F65.8 °F65.852 %NNE4.5 mph5.4 mph29.38 in0.00 in0.00 in
0​
w/m²
9/2/22 9:04 PM​
59.3 °F55.0 °F55.088 %NE3.4 mph4.1 mph29.50 in0.00 in0.00 in
0​
w/m²
9/3/22 1:04 AM​
55.6 °F53.8 °F53.896 %WSW0.0 mph0.0 mph29.56 in0.00 in0.00 in
0​
w/m²
9/3/22 5:04 AM​
55.7 °F54.0 °F54.098 %SW0.0 mph0.0 mph29.59 in0.00 in0.00 in
0​
w/m²
9/3/22 9:04 AM​
61.0 °F57.0 °F57.089 %South1.5 mph2.6 mph29.65 in0.00 in0.00 in
0​
w/m²
9/3/22 1:04 PM​
72.3 °F57.5 °F57.561 %NNE1.2 mph1.5 mph29.65 in0.00 in0.00 in
0​
w/m²
9/3/22 5:04 PM​
74.7 °F58.4 °F58.457 %South1.0 mph1.4 mph29.63 in0.00 in0.00 in
0​
w/m²
9/3/22 9:04 PM​
61.9 °F58.0 °F58.086 %ESE0.2 mph0.5 mph29.65 in0.00 in0.00 in
0​
w/m²
9/4/22 1:04 AM​
53.1 °F53.0 °F53.098 %SW0.0 mph0.0 mph29.63 in0.00 in0.00 in
0​
w/m²
9/4/22 5:04 AM​
50.4 °F49.0 °F49.099 %SSW0.0 mph0.0 mph29.63 in0.00 in0.00 in
0​
w/m²
9/4/22 9:04 AM​
58.8 °F56.9 °F56.994 %SSE2.5 mph3.9 mph29.64 in0.00 in0.00 in
0​
w/m²
9/4/22 1:04 PM​
77.2 °F58.0 °F58.053 %West4.9 mph6.2 mph29.62 in0.00 in0.00 in
0​
w/m²
9/4/22 5:04 PM​
72.8 °F63.0 °F63.070 %NNW1.3 mph1.9 mph29.61 in0.00 in0.00 in
0​
w/m²
9/4/22 9:04 PM​
59.4 °F55.0 °F55.087 %East0.0 mph0.0 mph29.65 in0.00 in0.00 in
0​
w/m²
9/5/22 1:04 AM​
49.4 °F49.0 °F49.099 %South0.0 mph0.0 mph29.68 in0.00 in0.00 in
0​
w/m²
9/5/22 5:04 AM​
44.9 °F44.0 °F44.099 %SW0.0 mph0.0 mph29.71 in0.00 in0.00 in
0​
w/m²
9/5/22 9:04 AM​
55.5 °F53.4 °F53.495 %NE0.2 mph0.2 mph29.75 in0.00 in0.00 in
0​
w/m²
9/5/22 1:04 PM​
75.8 °F56.4 °F56.452 %NNE4.7 mph5.4 mph29.72 in0.00 in0.00 in
0​
w/m²
9/5/22 5:04 PM​
77.0 °F52.0 °F52.043 %ENE4.7 mph6.0 mph29.65 in0.00 in0.00 in
0​
w/m²
9/5/22 9:04 PM​
63.0 °F42.0 °F42.048 %NNW1.4 mph2.2 mph29.62 in0.00 in0.00 in
0​
w/m²
9/6/22 1:04 AM​
56.8 °F46.0 °F46.067 %ENE1.6 mph2.2 mph29.60 in0.00 in0.00 in
0​
w/m²
9/6/22 5:04 AM​
51.8 °F47.0 °F47.086 %ENE1.0 mph1.9 mph29.59 in0.00 in0.00 in
0​
w/m²
9/6/22 9:04 AM​
61.5 °F50.6 °F50.670 %NE4.4 mph4.8 mph29.59 in0.00 in0.00 in
0​
w/m²
9/6/22 1:04 PM​
79.5 °F55.4 °F55.444 %East3.8 mph4.5 mph29.54 in0.00 in0.00 in
0​
w/m²
9/6/22 5:04 PM​
85.4 °F54.3 °F54.334 %ENE6.9 mph7.7 mph29.51 in0.00 in0.00 in
0​
w/m²
9/6/22 9:04 PM​
67.6 °F52.0 °F52.058 %NNE1.6 mph2.0 mph29.54 in0.00 in0.00 in
0​
w/m²
9/7/22 1:04 AM​
61.1 °F49.0 °F49.067 %NE2.6 mph3.7 mph29.56 in0.00 in0.00 in
0​
w/m²
9/7/22 5:04 AM​
53.8 °F48.0 °F48.082 %ENE0.0 mph0.0 mph29.61 in0.00 in0.00 in
0​
w/m²
9/7/22 9:04 AM​
63.2 °F49.0 °F49.062 %NE2.7 mph3.4 mph29.69 in0.00 in0.00 in
0​
w/m²
9/7/22 1:04 PM​
74.0 °F52.1 °F52.148 %NNE4.1 mph5.1 mph29.71 in0.00 in0.00 in
0​
w/m²
9/7/22 5:04 PM​
81.6 °F55.6 °F55.641 %NE4.7 mph5.2 mph29.70 in0.00 in0.00 in
0​
w/m²
9/7/22 9:04 PM​
61.1 °F45.0 °F45.058 %NE2.2 mph3.3 mph29.73 in0.00 in0.00 in
0​
w/m²
9/8/22 1:04 AM​
47.7 °F44.0 °F44.086 %West0.0 mph0.0 mph29.78 in0.00 in0.00 in
0​
w/m²
9/8/22 5:04 AM​
40.2 °F39.0 °F39.096 %WSW0.0 mph0.0 mph29.79 in0.00 in0.00 in
0​
w/m²
9/8/22 9:04 AM​
53.8 °F49.6 °F49.687 %East0.1 mph0.4 mph29.82 in0.00 in0.00 in
0​
w/m²
9/8/22 1:04 PM​
75.5 °F51.6 °F51.645 %NNE5.6 mph6.9 mph29.75 in0.00 in0.00 in
0​
w/m²
9/8/22 5:04 PM​
77.9 °F47.5 °F47.534 %NE3.8 mph4.2 mph29.65 in0.00 in0.00 in
0​
w/m²
9/8/22 9:04 PM​
61.5 °F45.9 °F45.959 %NE2.7 mph3.1 mph29.64 in0.00 in0.00 in
0​
w/m²
9/9/22 1:04 AM​
55.0 °F46.9 °F46.974 %North3.0 mph4.4 mph29.62 in0.00 in0.00 in
0​
w/m²
9/9/22 5:04 AM​
54.6 °F47.0 °F47.075 %NNE1.4 mph2.2 mph29.58 in0.00 in0.00 in
0​
w/m²
9/9/22 9:04 AM​
61.7 °F52.3 °F52.372 %ENE2.5 mph3.4 mph29.56 in0.00 in0.00 in
0​
w/m²
9/9/22 1:04 PM​
78.2 °F54.2 °F54.243 %NNE7.9 mph9.6 mph29.47 in0.00 in0.00 in
0​
w/m²
9/9/22 5:04 PM​
79.8 °F53.0 °F53.039 %NE5.0 mph6.6 mph29.39 in0.00 in0.00 in
0​
w/m²
9/9/22 9:04 PM​
64.8 °F47.0 °F47.055 %
0​
1.4 mph2.2 mph29.38 in0.00 in0.00 in
0​
w/m²
9/10/22 1:04 AM​
55.9 °F46.0 °F46.073 %NNE1.8 mph2.4 mph29.38 in0.00 in0.00 in
0​
w/m²
9/10/22 5:04 AM​
51.2 °F45.9 °F45.981 %NW0.0 mph0.0 mph29.37 in0.00 in0.00 in
0​
w/m²
9/10/22 9:04 AM​
62.9 °F48.4 °F48.461 %WSW1.6 mph1.9 mph29.38 in0.00 in0.00 in
0​
w/m²
9/10/22 1:04 PM​
85.2 °F52.8 °F52.834 %North3.5 mph4.4 mph29.35 in0.00 in0.00 in
0​
w/m²
9/10/22 5:04 PM​
85.3 °F51.9 °F51.932 %East0.0 mph0.0 mph29.35 in0.00 in0.00 in
0​
w/m²
9/10/22 9:04 PM​
60.3 °F53.5 °F53.578 %NNW0.0 mph0.0 mph29.40 in0.00 in0.00 in
0​
w/m²
9/11/22 1:04 AM​
52.7 °F49.5 °F49.590 %SSE0.0 mph0.0 mph29.48 in0.00 in0.00 in
0​
w/m²
9/11/22 5:04 AM​
57.2 °F53.0 °F53.088 %SW0.0 mph0.0 mph29.52 in0.00 in0.00 in
0​
w/m²
9/11/22 9:04 AM​
61.9 °F55.8 °F55.882 %NNW0.0 mph0.5 mph29.57 in0.00 in0.00 in
0​
w/m²
9/11/22 1:04 PM​
70.0 °F59.0 °F59.070 %NNE2.1 mph2.8 mph29.59 in0.00 in0.00 in
0​
w/m²
 

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type
Sort by date Sort by votes
Iis it having the temperature UOM (°F) in the data

Book1
AB
1TimeTemperature °F
29/1/22 1:04 AM53.8
39/1/22 5:04 AM57.4
49/1/22 9:04 AM58.6
59/1/22 1:04 PM72.3
69/1/22 5:04 PM86.4
79/1/22 9:04 PM64
89/2/22 1:04 AM62.4
99/2/22 5:04 AM53.7
109/2/22 9:04 AM57.8
119/2/22 1:04 PM78.1
129/2/22 5:04 PM85.3
139/2/22 9:04 PM59.3
149/3/22 1:04 AM55.6
159/3/22 5:04 AM55.7
169/3/22 9:04 AM61
179/3/22 1:04 PM72.3
189/3/22 5:04 PM74.7
199/3/22 9:04 PM61.9
209/4/22 1:04 AM53.1
219/4/22 5:04 AM50.4
229/4/22 9:04 AM58.8
239/4/22 1:04 PM77.2
249/4/22 5:04 PM72.8
259/4/22 9:04 PM59.4
269/5/22 1:04 AM49.4
279/5/22 5:04 AM44.9
289/5/22 9:04 AM55.5
299/5/22 1:04 PM75.8
309/5/22 5:04 PM77
319/5/22 9:04 PM63
329/6/22 1:04 AM56.8
339/6/22 5:04 AM51.8
349/6/22 9:04 AM61.5
359/6/22 1:04 PM79.5
369/6/22 5:04 PM85.4
379/6/22 9:04 PM67.6
389/7/22 1:04 AM61.1
399/7/22 5:04 AM53.8
409/7/22 9:04 AM63.2
419/7/22 1:04 PM74
429/7/22 5:04 PM81.6
439/7/22 9:04 PM61.1
449/8/22 1:04 AM47.7
459/8/22 5:04 AM40.2
469/8/22 9:04 AM53.8
479/8/22 1:04 PM75.5
489/8/22 5:04 PM77.9
499/8/22 9:04 PM61.5
509/9/22 1:04 AM55
519/9/22 5:04 AM54.6
529/9/22 9:04 AM61.7
539/9/22 1:04 PM78.2
549/9/22 5:04 PM79.8
559/9/22 9:04 PM64.8
569/10/22 1:04 AM55.9
579/10/22 5:04 AM51.2
589/10/22 9:04 AM62.9
599/10/22 1:04 PM85.2
609/10/22 5:04 PM85.3
619/10/22 9:04 PM60.3
629/11/22 1:04 AM52.7
639/11/22 5:04 AM57.2
649/11/22 9:04 AM61.9
659/11/22 1:04 PM70
Sheet2

1669716103166.png
 
Upvote 0
did you use an equation to change that or just make a custom format for that number?
 
Upvote 0
No just selected your temperature column and did a find and replace to remove all the °F from the value

1669752833268.png
 
Upvote 0
You must log in or register to reply here.

Similar threads

JenniferMurphy
  • Question Question
I could use help with a bit of a complex table addressing problem
Replies
1
Views
213
JenniferMurphy
JenniferMurphy
J
  • Solved
VBA Code To Loop Through One Worksheet and Paste Certain Values Into Another
Replies
5
Views
137
Peter_SSs
Peter_SSs
A
  • Solved
How merging by sum DEBIT,CREDIT columns for each name
2 3
Replies
27
Views
304
Abdo
A
K
  • Question Question
Copy data from rows with the dates (Monday to Sunday)
Replies
1
Views
61
K_Stevs1
K
P
  • Solved
Not able to correct filter data date wise, Kindly correct my formula...
Replies
1
Views
175
Anthony47
A

Forum statistics

Threads
1,223,885
Messages
6,175,183
Members
452,615
Latest member
bogeys2birdies

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top