I am having trouble calculating consumption over a month times by 3 different prices. Anyone know how i can do this so that i can make a graph showing consumption over the month if it was times by 3 different prices?
If I've understood correctly what you need, how about creating three additional columns in your data table:
Column1 = Table[Consumption]*Price1
Column2 = Table[Consumption]*Price2
Column3 = Table[Consumption]*Price3
and using those columns for the chart?
For detailed advice, please provide sample data and your desired output.