I am trying to export a chart with three series of data(Gas, Water, Oil) like below:
Time Stamp (EDT) |
Gas |
Time Stamp (EDT) |
Water |
Time Stamp (EDT)
| Oil |
01/03/2023
18:00:00 |
8.69 |
01/03/2023 18:00:00 |
0.20 |
01/03/2023 18:00:00
| 1.0 |
When there is no data for Oil for certain dates, I want the excel export to show as below. How can I do this?
Time Stamp (EDT) |
Gas |
Time Stamp (EDT) |
Water |
Time Stamp (EDT) |
Oil |
01/03/2023
18:00:00 |
8.69 |
01/03/2023 18:00:00 |
0.20 |
No Data |
No Data |
Currently, the Oil Data is hidden and I don't see it in the export to excel.