Pivot chart layout to show multiple values on same line

Hi,

Does the column L month not relate to one of the Date columns B or C?

How open are you to recording your data in a slightly different way thus opening analysis by Pivot Table?

i.e. Largely as now except that the month column would contain a proper Date number, e.g. always say the first of the month, and column M would contain the Reading.

Better still since you mention wanting to analyse data by energy type I'd suggest a column for the meter type, i.e. Gas, ELectric, Water and alongside it a column for the meter reference.

So altogether
Columns A:F as now
G: Meter Type, e.f.g Gas , Water Electricity
H: Meter Ref
I: Month e.g. 1/1/2021
J: Reading e.g. 2626251

Some of those columns could be drip down data validation to assist date entry

The way I normally arrange these things is to have a single data entry row above the database in which the new values are entered, then a button which runs a macro that adds the new record to the database.

My suggestion was not seeking any new data, just recording what you already have but in a slightly different way. The only 'difference' is that I'm suggesting an entry like the word 'January' is entered on the base data sheet as a January date number proper, say 1/1/2021

How is the data populated on the Base Data sheet? I can't see any connections or links which implies it's being manually added. If that's the case and since no new data is different it could presumably be added as I described.

Perhaps it would help if you uploaded the ms form that the engineers use with an indication of how it moves from the phone to the Base Data.