How to visualise the costs per unit of several energy providers?

[StephenBall]

Hello,

energy providers usually charge a monthly fixed rate and a flexible consumption-based rate. Some only charge the later. This has implications for the overall costs based on projected consumption.

I want to enter the the fixed and flexible rate into excel and then get a graph that show for much consumption I would be charged which amount.

For example, one provider charges:
10,- EUR/month & 5.26 ct/kWh

Another provider charges:
0,- EUR/month & 7.13 ct/kWh

I want to see two lines in the graph representing each provider and how the overall price increase in line with increasing consumption. Let's say from 0-15000 kWh.

How do I have to configure excel in order to get such a graph?

Many thanks for your help.

Please excuse my use of non-technical language but I am new to excel and don't have the vocabulary to describe it in a better way.

Anyway, your help is much appreciated.

 

[shg]

One way:

[Table="width:, class:grid"][tr][td] [/td][td]

A​

[/td][td]

B​

[/td][td]

C​

[/td][td]

D​

[/td][td]

E​

[/td][/tr]
[tr][td]

1​

[/td][td]

​

[/td][td]

Provider A​

[/td][td]

Provider B​

[/td][td]

​

[/td][td]

​

[/td][/tr]

[tr][td]

2​

[/td][td]Cost per montk[/td][td]

$ 10.00​

[/td][td]

$ -​

[/td][td][/td][td][/td][/tr]

[tr][td]

3​

[/td][td]Cost per kWh[/td][td]

$ 0.0526​

[/td][td]

$ 0.0713​

[/td][td][/td][td][/td][/tr]

[tr][td]

4​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr][td]

5​

[/td][td]

Usage​

[/td][td]

Price​

[/td][td]

Price​

[/td][td][/td][td][/td][/tr]

[tr][td]

6​

[/td][td]

400​

[/td][td]

$ 31.04​

[/td][td]

$ 28.52​

[/td][td][/td][td]B6 and across and down: =B$2 + $A6*B$3[/td][/tr]

[tr][td]

7​

[/td][td]

600​

[/td][td]

$ 41.56​

[/td][td]

$ 42.78​

[/td][td][/td][td][/td][/tr]

[tr][td]

8​

[/td][td]

800​

[/td][td]

$ 52.08​

[/td][td]

$ 57.04​

[/td][td][/td][td][/td][/tr]

[tr][td]

9​

[/td][td]

1000​

[/td][td]

$ 62.60​

[/td][td]

$ 71.30​

[/td][td][/td][td][/td][/tr]

[tr][td]

10​

[/td][td]

1200​

[/td][td]

$ 73.12​

[/td][td]

$ 85.56​

[/td][td][/td][td][/td][/tr]

[tr][td]

11​

[/td][td]

1400​

[/td][td]

$ 83.64​

[/td][td]

$ 99.82​

[/td][td][/td][td][/td][/tr]

[tr][td]

12​

[/td][td]

1600​

[/td][td]

$ 94.16​

[/td][td]

$ 114.08​

[/td][td][/td][td][/td][/tr]

[tr][td]

13​

[/td][td]

1800​

[/td][td]

$ 104.68​

[/td][td]

$ 128.34​

[/td][td][/td][td][/td][/tr]

[tr][td]

14​

[/td][td]

2000​

[/td][td]

$ 115.20​

[/td][td]

$ 142.60​

[/td][td][/td][td][/td][/tr]

[tr][td]

15​

[/td][td]

2200​

[/td][td]

$ 125.72​

[/td][td]

$ 156.86​

[/td][td][/td][td][/td][/tr]

[tr][td]

16​

[/td][td]

2400​

[/td][td]

$ 136.24​

[/td][td]

$ 171.12​

[/td][td][/td][td][/td][/tr]
[/table]

 

[StephenBall]

Thank you for this excellent suggestion. Is there away to turn this numerical representation into visual graph with $ on the vertical and kWh on the horizontal axis and then to have lines or bars (I prefer lines similar to a stock exchange).

As provider A has high fixed costs (120/year) there will come a point when provide a will become cheaper than provide B. I would like to be able to see it as the point where the lines of both providers cross. However, I don't know how to create such visual outputs with excel.

Many thanks for your help.

 

[shg]

There is an ocean of resources available online. Here's the first hit on Google:

Basic Graphing with Excel