You need to do some experimenting to really understand charts. The data that you say you have is not quite clear so it will be difficult for someone to give you a simple answer. My suggestion is that you select the data and then set up your chart. You may find it helpful to review some information on creating charts for your version of excel. http://office.microsoft.com/en-us/ex...010200499.aspx