Stacked column chart

NK123

New member
Joined
Apr 7, 2018
Messages
15
Reaction score
0
Points
0
I have another ques. regarding the stacked column chart I want to create, could you help?
See attached workbook. In option3 tab, This is a AP aging report by (1) By Inv date and (2) by Received Date. I want to indicate the following for Invoice date and the Received date. the summarized data is real in option3 tab. I have manually created the result of 0-11. But It can be completely new look.
  1. Number of inv,
  2. Inv amount and
  3. The inv status

Thank you again.
 

Attachments

  • AP Aging Report.xlsx
    16.5 KB · Views: 13
Last edited by a moderator:
https://www.screencast.com/t/WqiFoXujY5Tb

Ignore if you have solved this (do not get onto site much). Slicer(1) will drive 2 charts(2/3) both theses charts driven off 2 pivot tables(5/6). Have power queried/Get data one of your summary tables on other tab and unpivoted it, result being data table 4. This may not be what you need and if so feel free to submit fictitious data in the exact format that you get it in and will adjust
 

Attachments

  • AP Aging Report.xlsx
    44.3 KB · Views: 5
Back
Top