Pivot chart layout to show multiple values on same line

Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.

Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.

To upload a file click the Go Advanced button at the foot of your post, look underneath the post area for the Manage Attachments section and take it from there.

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.