Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Many of the engineers in my organization is using the pivot tables to create charts in Excel. Often, the charts will have 2 or 3 levels of information on the X-axis (see attached image with 3 levels of info). I can't find a charting feature or method in QS to do the same. Appreciate the community's help with a solution.
Thanks!
Timsoh
Thanks Quy_Nguyen. Let me watch and experiment. regards, Tim
Hi Quy, I experimented with the drill down dimension and while it can do as per what the video described, it did not achieve what the Excel Pivot chart with 3 levels of info on the X-axis can give to the analysts. By drill in, I can see info at the breadcrumb level but not at the breadload level. Also the drill down can only apply to a single selection. Let's say I have the production lot measure data for every month from 2017-2019. The Excel pivot chart will be able to display each production lot's measure from 2017-2019 so we can see how we are doing for each month and a very quick comparison month on month, year on year, lot on lot or at which month after countermeasure implementation that there was a step improvement of the measure. For the drill down dimension approach, I can only select 1 year, drill down to the months, select 1 month before I can see the production lot for the month. I cannot select 2 years and drill down further. Any alternative suggestion?