I have a bar/column chart on a report which is based on fields from a query.
Horizontal axis is the [WeekNumber] field and the Vertical Axis is [StaffName]. This works fine!
However, I want to change this into a stacked bar chart with the [StaffName] columns being split into [RecordType] field. I've edited the current chart and changed the Type to a stacked chart but I can't find anywhere I can add a 3rd field.
Is it possible to have a a stacked chart with 2 fields? (Each bar will represent a StaffName and each section of the bars will be the RecordType]
Horizontal axis is the [WeekNumber] field and the Vertical Axis is [StaffName]. This works fine!
However, I want to change this into a stacked bar chart with the [StaffName] columns being split into [RecordType] field. I've edited the current chart and changed the Type to a stacked chart but I can't find anywhere I can add a 3rd field.
Is it possible to have a a stacked chart with 2 fields? (Each bar will represent a StaffName and each section of the bars will be the RecordType]
