please post a workbook and mock up what you would like to see as the desired result (i.e. enter manually)

I assume that with "chart" you are not referring to an Excel chart like a column or bar chart?