Lake Level Measurement Chart.

Butch-196

New Member
Joined
Sep 17, 2013
Messages
27
Hi Hopefully someone can help! I would like to display the following data as a chart, however the chart is only showing the time and not the date. I would also like the chart to have the percentage level and pump status displayed.
DateTimeBore Hole Pump StatusBore Hole Pump Status %Lake Level %
01/06/2022​
12:00:00​
on
100​
65​
01/06/2022​
13:00:00​
on
100​
66​
01/06/2022​
14:00:00​
on
100​
62​
01/06/2022​
15:00:00​
on
100​
67​
01/06/2022​
16:00:00​
on
100​
63​
01/06/2022​
17:00:00​
on
100​
61​
01/06/2022​
18:00:00​
on
100​
60​
01/06/2022​
19:00:00​
on
100​
64​
01/06/2022​
20:00:00​
on
100​
65​
01/06/2022​
21:00:00​
on
100​
63​
01/06/2022​
22:00:00​
on
100​
65​
01/06/2022​
23:00:00​
on
100​
63​
02/06/2022​
00:00:00​
off
50​
55​
02/06/2022​
01:00:00​
off
50​
55​
02/06/2022​
02:00:00​
off
50​
55​
02/06/2022​
03:00:00​
off
50​
55​
02/06/2022​
04:00:00​
off
50​
55​
02/06/2022​
05:00:00​
off
50​
55​
02/06/2022​
06:00:00​
off
50​
55​
02/06/2022​
07:00:00​
on
100​
65​
02/06/2022​
08:00:00​
on
100​
66​
02/06/2022​
09:00:00​
on
100​
62​
02/06/2022​
10:00:00​
on
100​
67​
02/06/2022​
11:00:00​
on
100​
63​
02/06/2022​
12:00:00​
on
100​
61​
02/06/2022​
13:00:00​
on
100​
60​
02/06/2022​
14:00:00​
on
100​
64​
02/06/2022​
15:00:00​
on
100​
65​
02/06/2022​
16:00:00​
on
100​
63​
02/06/2022​
17:00:00​
on
100​
65​
02/06/2022​
18:00:00​
on
100​
63​
02/06/2022​
19:00:00​
on
100​
63​
02/06/2022​
20:00:00​
on
100​
63​
1655387036371.png
 

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.

6StringJazzer

Well-known Member
Joined
Jan 27, 2010
Messages
2,384
Office Version
  1. 365
Platform
  1. Windows
  2. Mobile
You need to combine the time and date into a single column and use that for the x-axis. To use your existing data you would insert a new column and simply add them. Also make sure both these columns are date and time data, and not text strings.
$scratch.xlsm
ABCDEF
1DateTimeDate+TimeBore Hole Pump StatusBore Hole Pump Status %Lake Level %
201/06/202212:00:0001/06/2022 12:00:00on10065
301/06/202213:00:0001/06/2022 13:00:00on10066
401/06/202214:00:0001/06/2022 14:00:00on10062
501/06/202215:00:0001/06/2022 15:00:00on10067
601/06/202216:00:0001/06/2022 16:00:00on10063
701/06/202217:00:0001/06/2022 17:00:00on10061
801/06/202218:00:0001/06/2022 18:00:00on10060
901/06/202219:00:0001/06/2022 19:00:00on10064
1001/06/202220:00:0001/06/2022 20:00:00on10065
1101/06/202221:00:0001/06/2022 21:00:00on10063
1201/06/202222:00:0001/06/2022 22:00:00on10065
1301/06/202223:00:0001/06/2022 23:00:00on10063
1402/06/202200:00:0002/06/2022 00:00:00off5055
1502/06/202201:00:0002/06/2022 01:00:00off5055
1602/06/202202:00:0002/06/2022 02:00:00off5055
1702/06/202203:00:0002/06/2022 03:00:00off5055
1802/06/202204:00:0002/06/2022 04:00:00off5055
1902/06/202205:00:0002/06/2022 05:00:00off5055
2002/06/202206:00:0002/06/2022 06:00:00off5055
2102/06/202207:00:0002/06/2022 07:00:00on10065
2202/06/202208:00:0002/06/2022 08:00:00on10066
2302/06/202209:00:0002/06/2022 09:00:00on10062
2402/06/202210:00:0002/06/2022 10:00:00on10067
2502/06/202211:00:0002/06/2022 11:00:00on10063
2602/06/202212:00:0002/06/2022 12:00:00on10061
2702/06/202213:00:0002/06/2022 13:00:00on10060
2802/06/202214:00:0002/06/2022 14:00:00on10064
2902/06/202215:00:0002/06/2022 15:00:00on10065
3002/06/202216:00:0002/06/2022 16:00:00on10063
3102/06/202217:00:0002/06/2022 17:00:00on10065
3202/06/202218:00:0002/06/2022 18:00:00on10063
3302/06/202219:00:0002/06/2022 19:00:00on10063
3402/06/202220:00:0002/06/2022 20:00:00on10063
charting
Cell Formulas
RangeFormula
C2:C34C2=A2+B2


Picture1.jpg
 

Forum statistics

Threads
1,175,792
Messages
5,899,517
Members
434,778
Latest member
Alina N

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
Top