Import Electric Energy & Create Graph

[georgegraz]

I have a .csv from the Electric Company. I'm trying to graph the 24 Hour data, without manually setting up the data. What is the best day to do it? I want it to look like the uploaded screen shot. The data is suppose to be from Xl2BB.
Thanks
George

START_TIME	END_TIME	VALUE	UNIT
2024-02-13T19:00:00-05:00	2024-02-13T19:15:00-05:00	1.362464​	KWH
2024-02-13T19:15:00-05:00	2024-02-13T19:30:00-05:00	1.305026​	KWH
2024-02-13T19:30:00-05:00	2024-02-13T19:45:00-05:00	0.823519​	KWH
2024-02-13T19:45:00-05:00	2024-02-13T20:00:00-05:00	0.870765​	KWH
2024-02-13T20:00:00-05:00	2024-02-13T20:15:00-05:00	0.896236​	KWH
2024-02-13T20:15:00-05:00	2024-02-13T20:30:00-05:00	0.877413​	KWH
2024-02-13T20:30:00-05:00	2024-02-13T20:45:00-05:00	0.914966​	KWH
2024-02-13T20:45:00-05:00	2024-02-13T21:00:00-05:00	0.751408​	KWH
2024-02-13T21:00:00-05:00	2024-02-13T21:15:00-05:00	0.799052​	KWH
2024-02-13T21:15:00-05:00	2024-02-13T21:30:00-05:00	0.761134​	KWH
2024-02-13T21:30:00-05:00	2024-02-13T21:45:00-05:00	0.714381​	KWH
2024-02-13T21:45:00-05:00	2024-02-13T22:00:00-05:00	0.756794​	KWH

National Grid 2-14-24.xlsx
	A	B	C	D
1	START_TIME	END_TIME	VALUE	UNIT
2	2024-02-13T19:00:00-05:00	2024-02-13T19:15:00-05:00	1.362464	KWH
3	2024-02-13T19:15:00-05:00	2024-02-13T19:30:00-05:00	1.305026	KWH
4	2024-02-13T19:30:00-05:00	2024-02-13T19:45:00-05:00	0.823519	KWH
5	2024-02-13T19:45:00-05:00	2024-02-13T20:00:00-05:00	0.870765	KWH
6	2024-02-13T20:00:00-05:00	2024-02-13T20:15:00-05:00	0.896236	KWH
7	2024-02-13T20:15:00-05:00	2024-02-13T20:30:00-05:00	0.877413	KWH
8	2024-02-13T20:30:00-05:00	2024-02-13T20:45:00-05:00	0.914966	KWH
9	2024-02-13T20:45:00-05:00	2024-02-13T21:00:00-05:00	0.751408	KWH
10	2024-02-13T21:00:00-05:00	2024-02-13T21:15:00-05:00	0.799052	KWH
11	2024-02-13T21:15:00-05:00	2024-02-13T21:30:00-05:00	0.761134	KWH
12	2024-02-13T21:30:00-05:00	2024-02-13T21:45:00-05:00	0.714381	KWH
13	2024-02-13T21:45:00-05:00	2024-02-13T22:00:00-05:00	0.756794	KWH
data (1)

 

[dermie_72]

If you highlight start_time and Value with all the data, Insert Chart, pick a 2d column chart and then format the axis so the data is readable.

 

[georgegraz]

If you highlight start_time and Value with all the data, Insert Chart, pick a 2d column chart and then format the axis so the data is readable.
View attachment 106882

That worked, thanks. I ended up selecting it under "More Column Charts". I ended up like your right one. How would I show that with only the time part. Then I could put the Month & day where value is? I know I can do it by using the replace command. Just wondering if there was an easier way?
Thanks again for the quick response. George

 

[dermie_72]

I believe that the easiest way would be to add a column to just show the time then use that as your reference. The problem is that you original data is showing as text so formatting it wont work.

 

[georgegraz]

I believe that the easiest way would be to add a column to just show the time then use that as your reference. The problem is that you original data is showing as text so formatting it wont work.

Dermie_72, thank you so much. I can live with what it looks like. George