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

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.
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
232
JenniferMurphy
JenniferMurphy
R
  • Solved
Round to nearest
Replies
4
Views
102
Joe4
Joe4
C
  • Question Question
Sumifs with Date Criteria
Replies
2
Views
56
Peter_SSs
Peter_SSs
A
  • Question Question
Extract Brands contains different prices with comparison original prices
2 3
Replies
20
Views
280
kvsrinivasamurthy
K
D
  • Solved
New formula for cumulative values
Replies
6
Views
195
djclements
djclements

Forum statistics

Threads
1,224,822
Messages
6,181,165
Members
453,021
Latest member
Justyna P

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