can't make graph from data

D

dmheller

Board Regular
Joined
May 26, 2017
Messages
142
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

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.
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

C
  • Question
Total Specific Sections in Auto-filled Spreadsheet
Replies
3
Views
74
Cubist
Cubist
A
  • Solved
Problem with multiple IFS, IF and AND in long formula
Replies
2
Views
195
arendberg
A
JenniferMurphy
  • Solved
Is there a better way to format table headers?
Replies
9
Views
213
shift-del
shift-del
H
  • Solved
Copy the first line and paste it at the start of all subsequent sheets in the same tab
Replies
4
Views
185
harzer
H
U
  • Solved
Index formula with matching - Can it look at rows and columns?
Replies
2
Views
127
usnapoleon
U

Forum statistics

Threads
1,215,753
Messages
6,126,677
Members
449,327
Latest member
John4520

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