nbk95jg
New Member
- Joined
- May 5, 2011
- Messages
- 21
Hey Everyone,
I have 1 data set with a bunch of columns, the ones needed for this question are Column H (header: Created, shows a list of dates when a specific request was created) and Column AK (header: Status, shows the status of the created request [i.e. Approved; Invalid; etc])
I need a line chart that will have a line showing how many loans were created for a week (showing daily break down) and a line underneath, showing how many of those were in an Invalid and Declined status.
I cant find a way to add both Column H and AK in a pivot next to eachother, to then create a Line Chart.
Any suggestions?
I have 1 data set with a bunch of columns, the ones needed for this question are Column H (header: Created, shows a list of dates when a specific request was created) and Column AK (header: Status, shows the status of the created request [i.e. Approved; Invalid; etc])
I need a line chart that will have a line showing how many loans were created for a week (showing daily break down) and a line underneath, showing how many of those were in an Invalid and Declined status.
I cant find a way to add both Column H and AK in a pivot next to eachother, to then create a Line Chart.
Any suggestions?
