Line Chart to do Trend Analysis - No idea how to even start!

[thanhie]

Hello expert excel users,

In the attached file there are two worksheets - utilities and then garbage. My company needs to meet certain KPI's given to us by PG&E - our utilities company.

I honestly don't even know how and where to start with this graph. I pretty much just know that i need to go to insert, choose the line graph i want, and that's about it.

PLEASE HELP!

What i would like the graph to show is the date at the bottom. Then on the left hand side i'd like for it to show the total amount of charges. I'd like for the lines to represent the five different locations. I'd also like to separate electrical charges and gas charges - is this possible or do i need to make two separate charts?

i pretty much want to show the trend in usage. Then i will need to do a trend analysis which is another thing i can choose on the chart i believe. please advise.

THANK YOU SO MUCH YOU DON'T KNOW HOW MUCH THIS MEANS TO ME!

[Andy Pope]

You can probably do most of what you want using pivot table / chart