Line chart question

[Anonymous]

wondering if i could pls get some help with the line chart. I am trying to show power consumption data on it by each month and different locations where power is generated. Currently when i try plot the information it just creates one line for the line chart, however i would like it to have one line for each of the different sites. How is this possible?

Cheers Sal

[Greg_Deckler]

Put your site column in the Legend.

[Anonymous]

Still didnt work. These are my 3 factors. Site is the different locations, date is for everyday for a year for all of the sites and consumption is how much is consumed. I want to be able to see lines of every site over months for their consumption levels. THese are the 3 factors, how do i organise them. Cheers

[Greg_Deckler]

Date should be in Axis and Consumption should be Value