Graphs (plotly / apex) aggregating data/values in new line/bar?

I am not sure if I am missing the options but am trying to use data presented to graphs and create a total line out of them. Am trying to avoid the need of a template sensor just-for-this and it seems simple but I cannot find it. I am using plotly or apex-charts…open to other options where known
Example: energy from plug1 + energy from plug2 = (new line) energy room 1