Good morning,
I have been tasked with making a spreadsheet that documents the expected and invoiced purchases from clients. The given rows are as such: there are 6 levels of purchase and the table keeps track of the expected, invoiced, and expected cost of each of them. The columns corelate to the clients. The first column is the sum of the subsequent columns. How do I make it so that if I add a new column, it adds that value to the running sum, and then adds the sum values to separate charts?
Hi
please post a sample sheet as explained in the yellow banner. Thx
Sure, a simplified version is attached here, but I'm sure I can extrapolate whatever information you give to me to apply to all 6 service levels
Hello Chistopher and Welcome to Excel Forum.I have been tasked with making a spreadsheet...
Sounds like this is in the early stages, so I would suggest changing the arrangement of the data into a record format as modeled in A10:D28
If that is done then it may be possible that Pivot Charts can be used to display the totals as modeled below the pivot tables.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks