Hi I'm trying to put together a line graph with 6 data series but am running into some problems due to inconsistent values in the X axis.
My data involves sales information for 6 salesmen. I want my X axis to represent time and the Y axis to represent cumulative sales. I want to have a line/series for each member of the sales team plotting their cumulative sales over time. The cumulative sales total is calculated every day that a sale is made by that member. The problem is that all sales data does not occur on the same day. For some days there are multiple sales, other days no sales, and for some days one or two individuals made sales. I'm pretty inexperienced with Excel graphing but am assuming there's got to be a way around this. I think that I might need to rearrange my data into horizontal columns, but if I were to do that I would have many empty cells (since not every salesman made a sale on every date). Plus, it would take a very long time to manually input each cell value in the right place.
Here is an example of the data (sorted by date): https://dl.dropbox.com/u/5685397/graphexample.xlsx
Any suggestions would be great. Thanks!
Bookmarks