From my Pivot table I have inserted a Line Chart to depict the number of defects that were "fixed in an event" Vs. when they were "Detected". The Pivot and chart are working with the exception of 1 thing:
- seems like the "Fixed In Event" grouping values do not always appear on the chart axis (some are left blank for no apparent reason????) the "Detected in Event" values all appear. Any suggestions?
am using a Pivot Chart to create a Line Chart where the X Axis of my chart depicts a grouping (by month
Pivot Chart Settings:
Row Labels: (In this order)
Fixed in Event
Detected in Event
Sum Values:
Count of Defect
- seems like the "Fixed In Event" grouping values do not always appear on the chart axis (some are left blank for no apparent reason????) the "Detected in Event" values all appear. Any suggestions?
am using a Pivot Chart to create a Line Chart where the X Axis of my chart depicts a grouping (by month
Pivot Chart Settings:
Row Labels: (In this order)
Fixed in Event
Detected in Event
Sum Values:
Count of Defect
